DATA Step, Macro, Functions and more

BASIC PROC COMPARE HELP

Reply
Occasional Contributor
Posts: 6

BASIC PROC COMPARE HELP

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_var1var2
_Diff_EE
_Diff_EE
_Diff_EE
_Diff_EE

 

**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

 

PROC Star
Posts: 1,283

Re: BASIC PROC COMPARE HELP

Posted in reply to himalayancat

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?

Super User
Posts: 13,548

Re: BASIC PROC COMPARE HELP

Posted in reply to himalayancat

@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.

Ask a Question
Discussion stats
  • 2 replies
  • 62 views
  • 0 likes
  • 3 in conversation