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
How to export list/table to excel with blank row as group separatorHello, Hoping someone has a hack to insert a blank row as a group separator when I export a list to …
How can I Export Nested Probit Analysis Results to Word document?Hi all, I ran probit and margin with Stata 14.2 for six different years. I used the esttab command …
Appropriate regression modelMy dataset consists of an amount of lubricant added to a process at various times. The lubricant is …
Interacting dummy variable for missing value in continuous variablehi I am trying to run a linear regression where some of the values in one of the independent variab…
mi impute - irr option not working after my commandHi all, I am using the Code: mi impute/mi estimate: command to try and estimate a multilevel poiss…
Subscribe to:
Post Comments (Atom)
0 Response to Local macro in "forvalues" function
Post a Comment