Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: comparing 2 datasets, cf3, and output options


From   "Steichen, Thomas J." <[email protected]>
To   <[email protected]>
Subject   st: RE: comparing 2 datasets, cf3, and output options
Date   Tue, 13 Dec 2005 15:18:15 -0500

Carol Kolb writes:
> I am trying to compare 2 versions of a single dataset that is 
> being entered by 2 different people (double-data-entry of a 
> large survey). I have used the cf3 command to generate the 
> list of matches & mismatches. What I would like to do is have 
> these matches/mismatches listed by survey/household rather 
> than by variable. Given there are 2000 surveys & 100 
> variables, it would make the correction-process tremendously 
> easier for my staff. So, what I would like to see is this:
> 
> Household code: XX-DD-123
> q00  match
> q01  mismatch
>        _q01   q01   HHcode
>            1         2    XX-DD-123
> q02 .... etc.
> 
> Household code: YY-DD-123
> q00 mismatch
>       _q00     q00   HHcode
>           2          4      YY-DD-123
> q01 match
> 
> ---------
> 
> Rather than:
> q00 mismatch
> obs  _q00    q00    HHcode
> 12       2          4       YY-DD-123
> 32       3          2       YD-DE-129
> 
> q01 mismatch
> obs   _q01   q01   HHcode
> 21        1        2      XX-DD-123
> 33        3        3      YD-DE-129
> 
> Any ideas? By commands do not work with cf3 from what I can 
> tell so far...

Carol,

I'm the author of -cf3-. As you suspect, there is no built-in way change the output structure, as the code must completely process a
given variable before moving to the next. Given the logic of -cf3-, it would be far easier to write a completely new program than to
try to edit this one to generate your output style.  Simpler yet may be to capture the output from -cf3- and post-process it into
your new structure. 

Tom Steichen



-----------------------------------------
CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the
attorney-client or other legal privileges, and/or proprietary non-
public information. If you are not an intended recipient of this
message or an authorized assistant to an intended recipient, please
notify the sender by replying to this message and then delete it from
your system. Use, dissemination, distribution, or reproduction of this
message and/or any of its attachments (if any) by unintended recipients
is not authorized and may be unlawful.


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