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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.