Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: re: checking for common data entries across variables


From   "Devendra Amre" <[email protected]>
To   statalist <[email protected]>
Subject   st: re: checking for common data entries across variables
Date   Mon, 23 Apr 2007 14:01:49 -0400

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index