topic Re: BASIC PROC COMPARE HELP in SAS Programming

BASIC PROC COMPARE HELP

himalayancat — Fri, 13 Jul 2018 16:37:43 GMT

hello all,

I ran a proc compare

not the exact data but mimic. but i am trying to recreate it.

data d1;

format x =12.5;

informat x=12.5;

x=0.39990;

run;

data d2;

format y =8.4;

informat y=8;

data var2;

y=0.3999;

run;

proc compare base=d1 compare=d2
outdiff outnoequal listequalvar listcompvar
listbasevar
method=absolute
criterion=0.0001
out=dboth;
run;

************output*****************

_type_	var1	var2
_Diff_	E	E
_Diff_	E	E
_Diff_	E	E
_Diff_	E	E

**my question**

1.i don't know how to interpret these 'E'.

2.when does it shows up

3.does it means E =equal??

4.would proc compare results in E Instead of 0 when used with criterion=0.0001 and method=absolute

Re: BASIC PROC COMPARE HELP

PeterClemmensen — Fri, 13 Jul 2018 18:57:52 GMT

I don't see that output at all. I see some data steps with errors in them?

Are you sure this is the correct code you have posted?

Re: BASIC PROC COMPARE HELP

ballardw — Fri, 13 Jul 2018 19:26:30 GMT

@himalayancat wrote:

hello all,

I ran a proc compare

not the exact data but mimic. but i am trying to recreate it.

data d1;

format x =12.5;

informat x=12.5;

x=0.39990;

run;

data d2;

format y =8.4;

informat y=8;

data var2;

y=0.3999;

run;

Format and Informat statements do not use the = .

data set d2 would have zero observations.

Re: BASIC PROC COMPARE HELP

himalayancat — Fri, 20 Jul 2018 03:31:58 GMT

Thank you,

i get that.appreciate it.

can you tell me

what exactly does criterion does.

a=5.005

b=4.004

,say ,we ran proc compare on this,

with criterion 0.001, are we saying say to not bother the diff of 0.001 and consider it as equal???

and,

with exact match,

say

a=2

b=2

with proc compare it used to come 0 with exact match in the result,now it shows 'E'.

does that E means equal??