My first post here, but have used this forum extensively in the past to trouble shoot. However, can't find a solution to my stata problem, if there is one.
I have a series of variables from DX1, DX2, DX3 ... DX25.
Variables DX1 - DX25 have a diagnostic code, which is a string value.
I'm trying to recreate a new variable that searches DX1-25, and pulls the diagnostic codes I am interested in.
Write now, I have this code:
gen AKI=0
forvalues j=1/25{
replace AKI=1 if inlist(DX`j', "5845", "5846", "5847", "5848", "5849")
}
But the problem is, for the inlist function, I can't include more than 5-10 string variables in the "inlist" function. For some new variables I am trying to generate, it will be based on 100s of diagnostic codes. So I thought if I use a macro with my string variables predefined, then I could avoid the 5-10 limit.
I've tried creating the following macro and incorporating it into my loop:
local aki "5845" "5846" "5847" "5848" "5849"
gen AKI=0
forvalues j=1/25{
replace AKI=1 if inlist(DX`j', "`x'")
}
And it doesn't work. The result is "0 real changes made"
Any help you might have would be tremendously appreciated. Thank you.
Related Posts with Local macro in "forvalues" function
Conditional logistic regressionHi! I am new to this forum and looking for some advice please. I have run a conditional logistic reg…
principal factor vs. principal-component factor option for factor analysis Hello everyone! Can someone explain me the difference between the "principal-factor" and "principa…
Monthly rolling regressions - recording residualsHi All, Thanks for reading. I currently have daily time series data for the periods from July 2010…
Comparing mortality rate over yearsDear Statlisters, I am trying to find : whether there is a "significant change in the mortality rate…
Represent Table to Line graphGreetings. I would want to transform my tabulation: ta bdcategory year to be represented in a line g…
Subscribe to:
Post Comments (Atom)
0 Response to Local macro in "forvalues" function
Post a Comment