Date:         Wed, 9 Feb 2005 14:58:56 -0800
Reply-To:     "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Subject:      Re: Proc Compare
Comments: To: "Ross, Michael D" <michael.ross@ASTRAZENECA.COM>
Content-Type: text/plain

Hi Ross,

This option combination will ignore comparing numbers,
but still compare the non-number fields.


data sample1;
     x = 25000;
     y = 'hello';
     output;
run;

data sample2;
     x = 15000;
     y = 'hello';
     output;
run;

proc compare data=sample1 compare=sample2
             method=percent criterion=100;
run;



Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investment Group


Russell
Global Leaders in Multi-Manager Investing








-----Original Message-----
From: Ross, Michael D [mailto:michael.ross@ASTRAZENECA.COM]
Sent: Wednesday, February 09, 2005 2:21 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Compare


Hi All,
 Is there an option to have Proc compare not evaluate the difference between
two numbers?

Proc compare will do this:
new  25000
old  15000
diff 10000

 Instead have:
new  25000
old  15000
diff xxxxx


Tx.