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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.