topic Re: compare in SAS Programming

compare

ravindra2 — Thu, 06 Dec 2018 10:09:41 GMT

how to compare two datasets with proc sql ?

Kurt_Bremser — Thu, 06 Dec 2018 10:11:15 GMT

Maxim 14: Use the Right Tool. Which is proc compare.

For more details, post example data for your datasets (in data steps with datalines), and what you want to particularly compare.

PeterClemmensen — Thu, 06 Dec 2018 10:16:10 GMT

In most cases, PROC COMPARE is the way to go here. What do you want to compare? Be more specific please

RW9 — Thu, 06 Dec 2018 10:51:47 GMT

In what sense? If you want those in one not the other, then you could do:

proc sql;
  create table want as
  select * 
  from   table1
  except 
  select * 
  from   table2;
quit;

But generally proc compare would be better.

Clash — Thu, 06 Dec 2018 11:11:25 GMT

Hi!

Similiar to Proc Sql with execpt you could use merge -->

Data _Class_1 _Class_2 ;
Set sashelp.class ;

OUTPUT ;
if name = "Alfred" then do ;
name ="Anders" ;
OUTPUT _Class_2 ;
end ;
Run ;

Proc Sort Data=_Class_1 ;
BY _all_ ;
Run ;

Proc Sort Data=_Class_2 ;
BY _all_ ;
Run ;

Data _in_both
_only_Class_1
_only_Class_2 ;

Merge _Class_1(in=in1) _Class_2(in=in2) ;
BY _all_ ;

if in1=1 then do ;
if in2=1 then OUTPUT _in_both ;

else OUTPUT _only_Class_1 ;

end ;

else OUTPUT _only_Class_2 ;
Run ;

Though, Proc Compare would be the best choice...

Regards,

VDD — Thu, 06 Dec 2018 12:45:05 GMT

maybe something like this

proc compare base = _only_Class_1
compare = _only_Class_2 out=review outall outnoequal;
by _all_;
run;