You can nest -foreach- loops. That's a standard
and useful device. I can't say whether it's best
here.
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Jarrod P
> Franklin
> Sent: 15 March 2004 14:20
> To: [email protected]
> Subject: st: looping using two variables
>
>
> Hi,
>
> I am wondering if it is possible to do something like
> 'foreach' except
> over two different variables. I will clarify.
>
> I want to run a loop that opens a data file (say A) and
> generates a new
> variable (x1) which is equal to a variable already in the
> dataset. It will
> then open my original data set (say B) and merge B with A using
> another variable (y1). This is to allow me to compare the
> first instance
> of y (I have 21 different variables meaning the same thing but each
> combination is different for each patient ID), with the first
> instance of x.
>
> The problem is that each time the loop is run, I need to
> generate a new
> variable (x2, x3,...) which I can then take back to the data
> set B and
> tag on to the end using merge but with a different variable
> again (y2,
> y3,...).
>
> I need to do this 21 times (which is why I am hoping to find a way of
> looping over two variables).
>
> Note: x1=x2=...=x21, but y1,y2,...,y21 are all different
> (from each other
> and all x1 to x21).
>
> Basically, each y has between 0 and ~300 ICD9 codes which I want to
> convert into ICD10 codes (found in x1, x2,...,x21) using a specific
> dataset I have acquired for this purpose. So what I am wanting is a
> corresponding ICD10 code for each occurrence of an ICD9 code so
> that x1 gives the corresponding icd10 code for each icd9 value in y1
> and so on for x2, y2, upto x21, y21.
>
> I hope this is possible and that my explanation has been clear enough
>
> Regards,
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
