Generating a new variable conditional on multiple values - using 'or' command?

[Emmanuel Claudo]

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

[Nick Cox]

You must have a list of those codes somewhere. I'd set this up as a merge. See https://www.stata.com/support/faqs/d...s-for-subsets/ for more.

[Emmanuel Claudo]

Thanks a lot, that worked out well!