st: re: checking for common data entries across variables

["Devendra Amre" <devendra.amre@gmail.com>]

Sorry the earlier message was incomplete..here the complete question..

Hi everyone,
Is there a STATA command similar to VLOOKUP that is available in EXCEL?
For example, I have a list of IDs as 2 variables. I wish to check if
any ID listed in var1 are present in var2..here is an example:

var1           var2
M101        F100
F100         M101
F120         F130
F145         M101

IDs M101 and F100 are common..is there some way of tagging these IDs?
Thanks in advance.

Devendra
*
*   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/