Date:         Tue, 3 Jul 2007 11:24:27 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: More proc compare problems

You have 2 OUT= options in your program. Is that the reason? As far as I
know will the OUTNOEQUAL option bring only the Obs which are unequal. I
think, your

out=result

is simply ignored. Is that a old output from a previous run?
Gerhard


On Tue, 3 Jul 2007 10:29:54 -0400, Simon, Lorna <Lorna.Simon@UMASSMED.EDU>
wrote:

>I followed Matt's suggestion, but now it's outputting all observations,
>instead of just the ones that don't match. Is there any way to get it to
>just output the non-matches. Here is my code:
>
>%let id=%str(id); /*Insert name of id variable(s) here*/
>%let library=temp;/*Insert name of library here*/
>%let data1=dlpage3; /*Insert name of 1st data file here*/
>%let data2=jgpage3; /*Insert name of 2nd data file here*/
>%let varlist=%str(fmps_c--fm16_2m fmsd_3--fmmed_e);
>%let dataout=result/*insert output data set name here*/;
>/*proc contents data=&library..&data1 position; run;*/
>
>proc sort data=&library..&data1; by &id; run;
>proc sort data=&library..&data2; by &id; run;
>
>PROC COMPARE base=&library..&data1 compare=&library..&data2
>MAXPRINT=(32767, 32767)
>                        /*stats*/ noprint out=&library..&dataout
>                                                out=result outnoequal
>outdif;
>id &id;
>*var &varlist;
>RUN;
>
>proc print data=&library..&dataout;
>run;
>
>Use the NOPRINT option of the PROC COMPARE statement as well as the OUT=
>option to write the data to an output SAS data set that you can then
>print with a PROC PRINT paragraph (cf., the PROC COMPARE documentation
>example that uses an OUT= data set).
>Moreover, use the OUTNOEQUAL, OUTBASE, OUTCOMP, and OUTDIF options.
>
>Matthew Zack
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Simon, Lorna
>Sent: Monday, July 02, 2007 10:40 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Proc compare truncating string variables
>
>Hi all. A colleague of mine is having a problem w/ proc compare. It's
>truncating some of her longer string variables in the output. Is there
>any way around this? I've checked help and could find nothing that
>addressed this. Thanks.