David Elliot--does this do what you want?
use data2
labmask code, val(desc)
keep code
merge code using data1, sort
(you can -findit labmask- to get the labutils I think)
On 9/12/07, David Elliott <[email protected]> wrote:
> I have a what is perhaps a related question.
>
> Imagine, as is frequently the case, we have a main file, eg:
> code measure1 measure2 ...
>
> with another cross-reference file containing:
> code description ...
>
> Such code cross-reference combinations are common when dumping from
> relational databases.
>
> Typically one might do a merge, but this can be a problem if the
> description is long and the main file is very large. What one really
> wants is the cross-reference file to provide value labels to the main
> file. This is both fast and parsimonious of space. I looked for such
> a program without success so I wrote my own. I would be interested if
> anyone knew of a user contributed program to do this, or if anyone
> else felt the need for such a program, in which case I might spruce it
> up for public consumption.
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
