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/
