Re: st: Compare values from two datasets

[Richard Goldstein <richgold@ix.netcom.com>]

rename one of the variables so they have the same name in each file; 
sort each file by that variable and then use the -merge- command

Rich

Gao Liu wrote:

> Hi, Statalist:
>
> I have two datasets A and B. I need to create a dummy variable in A to
> tell me whether the value of a string variable (say lic_no ) in A
> matches any value in the variable of psycho_lic_no in B. Simply put, I
> want to see whether the value for each obs. in A is on a list. But as
> the list (the value of psycho_lic_no in B) is so long (over 10000), it
> is inconvenient to copy and paste all the values, and compare them
> with the lic_no one by one.
>
> Any good way to make the job easier? Thank you.
>
> Best
>
> Gao
*
*   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/