|
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: AW: compare files, vars only
<>
Wow, this thing lingers on, but I think we have seen this variation
before...
http://www.stata.com/statalist/archive/2009-02/msg00826.html
HTH
Martin
_______________________
----- Original Message -----
From: "Jeph Herrin" <[email protected]>
To: <[email protected]>
Sent: Thursday, February 19, 2009 5:34 PM
Subject: Re: st: AW: compare files, vars only
I think
loc diff : list first - second
will only give the variables in the first file not in the
second, but ignores those in the second not in the first.
how about:
************* compare variables ********
program define compvars
syntax using/
tempname file1 file2 equiv diff1 diff2
quietly d , varlist
local `file1'=r(varlist)
quietly d using `using', varlist
local `file2'=r(varlist)
local `equiv' : list `file1'===`file2'
if ``equiv''!=1 {
local `diff1' : list `file1'-`file2'
local `diff2' : list `file2'-`file1'
di "Difference: "
di " In master not using: "
di " ``diff1''"
di " In using not master: "
di " ``diff2''"
}
else {
di "Difference: "
di " None! "
}
end
****************************************************
Whence:
. sysuse auto
. drop gear_ratio displacement
. save newauto,replace
. sysuse auto
. compvars using newauto
Difference:
In master not using:
displacement gear_ratio
In using not master:
hth,
Jeph
Johannes Geyer wrote:
what about:
*************
clear*
sysuse auto, clear
drop gear_ratio displacement
save newauto, replace
sysuse auto, clear
qui ds
loc first `r(varlist)'
des using auto, varlist
loc second `r(varlist)'
loc diff: list first - second
di in red "Differences: `diff'"
*************
-describe- does not need to load the dataset which may be of interest
here
Johannes
[email protected] schrieb am 19/02/2009 16:53:44:
<>
*************
clear*
sysuse auto, clear
drop gear_ratio displacement
save newauto, replace
sysuse auto, clear
qui ds
loc first `r(varlist)'
u newauto, clear
qui ds
loc second `r(varlist)'
loc diff: list first - second
di in red "Differences: `diff'"
*************
I am sure I have violated several rules on the possible lengths of
components in here (think 244...)
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von David
Kantor
Gesendet: Donnerstag, 19. Februar 2009 16:41
An: Statalist
Betreff: st: compare files, vars only
Hi.
Does anyone know of a program to compare the sets of variables in two
data files? What I have in mind is something akin to -cf-, but...
it would not compare values -- only the names of variables;
it would not care whether the two data files had the same number of
observations.
I was planning to write such a program, but I wanted to be sure that
it hadn't already been done.
Thanks
--David
*
* 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/
*
* 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/