Data Have1;
input id @@;
cards;
1 1 2 2 3 . .
;
run;
Data Have2;
input id @@;
cards;
1 1 2 2 2 4 . .
;
run;
In above program . . indicates missing values
By using joins how can i retrieve 3 , 4 i.e resultant dataset contain 3, 4 values from id variable.
data want;
merge
have1 (in=h1)
have2 (in=h2)
;
by id;
if not h1 or not h2;
run;
data want;
merge
have1 (in=h1)
have2 (in=h2)
;
by id;
if not h1 or not h2;
run;
Untested:
proc sql;
create table want as
select coalesce(h1.id,h2.id) as id
from have1 h1
full join have2 h2
where h1.id is missing or h2.id is missing
;
quit;
Data Have1; input id @@; cards; 1 1 2 2 3 . . ; run; Data Have2; input id @@; cards; 1 1 2 2 2 4 . . ; run; proc sql; create table want as (select id from have1 except select id from have2) union (select id from have2 except select id from have1) ; quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.