How can I merge data A and data B below to obtain C by ID;
DATA A;
input id p;
cards;
1 2
1 2
2 3
3 7
4 9
4 9
;
Data B;
input id t;
cards;
1 3
2 4
;
to obtain;
data c;
input id p t;
cards;
1 2 3
1 2 3
2 3 4
3 7 .
4 9 .
4 9 .
As long as you don't have duplicate IDs in B, then you could just use:
data c;
merge a b;
by id;
run;
As long as you don't have duplicate IDs in B, then you could just use:
data c;
merge a b;
by id;
run;
Thanks
Please try,
PROC SQL;
CREATE TABLE A_B AS
SELECT t2.t,
t1.id,
t1.p
FROM WORK.A t1
FULL JOIN WORK.B t2 ON (t1.id = t2.id);
QUIT;
Alternatively in datastep
data A_B;
merge a(in=a) b(in=b);
by id;
run;
Thanks,
Jag
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.