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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.