Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: looping using two variables

From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   st: RE: looping using two variables
Date   Mon, 15 Mar 2004 15:11:28 -0000

You can nest -foreach- loops. That's a standard 
and useful device. I can't say whether it's best 

[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:
> *
> *
> *

*   For searches and help try:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index