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
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: