I have a two tables I want to merge but do not want any null values coming over.
Table1: Ncolumn1 Ncolumn2
85758 230
Table2: Tcolumn1 Tcolumn2
4796 155
When I run this code:
Data Final; set table1 table2;
run;
I get
ncolumn1 ncolumn2 tcolumn1 tcolumn2
row1 85758 230
row2 4796 155
I just want it all to be 1 row with the data
Your program is very close to working. This should do it:
data final;
set table1;
set table2;
run;
There are plenty of complications if either of your data sets contains more than one observation. But you said they each have one, so let's leave it at that.
Good luck.
Why?
Unless your source tables always contains just one row, it makes no sense.
If this is the case, it's easier to use SQL with a Cartesian join.
Your program is very close to working. This should do it:
data final;
set table1;
set table2;
run;
There are plenty of complications if either of your data sets contains more than one observation. But you said they each have one, so let's leave it at that.
Good luck.
Hi,
Try this...
data want;
set one;set two;
run;
data want1;
merge one two;
run;
Thanks,
Shiva
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.