Hey,
I Hope someone can help me with this:
I have a dataset of households in various zip codes. I want to generate a variable that places the hholds into five different categories according to an area index of multiple deprivation using the zip codes that were correspondingly identified.
The logical way to do this in stata is to write a command that looks like this:
gen if aimd5=="12345" | zip=="82456" | zip=="56234" | zip==..............
replace if aimd5=="75687" | zip=="45688" | zip=="95689" | zip==..............
replace if aimd5=="14687" | zip=="34687" | zip=="64687" | zip==..............
replace if aimd5=="54687" | zip=="54645" | zip=="54687" | zip==..............
replace if aimd5=="64687" | zip=="78987" | zip=="21387" | zip==..............
There would be about 8000 "or" conditions The problem is, Stata doesn't allow this many "OR" conditions in that statement.
This command works fine if I only put in 10 zips or so.
Is there any way for me to perform this operation?
Kind regards
Related Posts with Generating a new variable conditional on multiple values - using 'or' command?
Need help with counting number of values for a variable in each group before a blank spaceHi, Please, need help counting the number of values for Ambtemp2oC_01 before a blank space for each …
Renvars replacement?Hi, I'm working on a group project with someone whose version still supports renvars, which mine doe…
export to several sheets using esttabHi. I am trying to export ttests using the esttab command and am unable to append the results to sev…
Panel DataI need help Can anyone give me an insight to the problem? my objective is to analyse the effect of i…
Interpretation of SYS-GMM coefficientsHello, I am bit unsure of whether my interpretaion of the coefficients is correct: The following are…
Subscribe to:
Post Comments (Atom)
0 Response to Generating a new variable conditional on multiple values - using 'or' command?
Post a Comment