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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.