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/