Data A ;
Input a b;
Cards;
2 .9
4 .8
9 .3
Data b
Input c;
Input a;
Cards;
1.9
4.7
8.8;
Merge them to have:
1.9 .
2 .9
4 .8
4.7 .
8.8 .
9 .3
Thanks
Just use MERGE statement.
Data A ;
Input a b;
Cards;
2 .9
4 .8
9 .3
run;
Data b;
Input a;
Cards;
1.9
4.7
8.8
run;
data c;
merge a b;
by a ;
run;
Alternatively by SQL
PROC SQL;
CREATE TABLE want AS
SELECT coalesce(t2.a,t1.a) AS a,
t1.b
FROM WORK.A t1
FULL JOIN WORK.B t2 ON (t1.a = t2.a);
QUIT;
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.