topic Re: proc compare equal vlues in SAS Programming

proc compare equal vlues

ciro — Wed, 06 May 2020 07:49:24 GMT

Hi,

I would like to identify the records that in proc compare output dataset have equal values in some numeric variables.

the problem is that numeric variables with equal values are marked as E. I don't know how to refer to this value. I have tried with varx=0 or varx=E or varx='E' or -0.1 le varx le 0.1 but none seems to work.

any suggestion is greatly appreciated

thank you in advance

Re: proc compare equal vlues

ChrisNZ — Wed, 06 May 2020 08:21:57 GMT

Maybe they are missing values.

Try VARX = .E

Re: proc compare equal vlues

Kurt_Bremser — Wed, 06 May 2020 09:13:37 GMT

Please post the whole code of the PROC COMPARE step, using the "little running man" button.

Re: proc compare equal vlues

JonathanWill — Wed, 06 May 2020 14:15:55 GMT

You've not an example of your code, but assuming you're looking at the diff output dataset from proc compare, it uses the missing value .E for equal.

So you can do something like

data thesame;
  set comparison(where=(fieldtocheck=.E));
run;

Sometimes forget that SAS has many different missing values (. .A -- .Z ._ , possibly others) and occasionally they are used to represent specific things.