I'm trying to use one data set as the reference list to replace values in another. I suspect the code looks something like this:

foreach i in `filename' {
gen var_new if var_old == var_reference;
}

The data set in mind has a numerical ID tied to other data; data set 2 has a string label for that numerical ID that I'd like to use. Tips?