If you use -cf- you have to use it in both directions, to be on the
safe side. However, -cf- compares all values as well, which will
clutter the output considerably if these are actually two different
datasets with the same variable names.
Here is a way to avoid this problem. The example uses the auto data.
****
sysuse auto, clear
drop foreign
save myauto1
sysuse auto, clear
drop price head
save myauto2
qui ds
local second `r(varlist)'
use myauto1, clear
qui ds
local first `r(varlist)'
foreach x of local first {
if strpos("`second'","`x'") == 0 {
di in yellow "`x' is not present in the second file."
}
}
foreach x of local second {
if strpos("`first'","`x'") == 0 {
di in yello "`x' is not present in the first file."
}
}
erase myauto1.dta
erase myauto2.dta
************************
Eva
2008/9/15 Martin Weiss <[email protected]>:
-h cf-
Martin Weiss
_______________________
----- Original Message ----- From: "Raphael Fraser"
<[email protected]>
To: <[email protected]>
Sent: Monday, September 15, 2008 10:42 PM
Subject: st: Comparing datasets
I have 300 variables in one dataset, 298 in another dataset. Both
datasets should have the same variable names. How can I identify which
variables do not match up?
Raphael
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
