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
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 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.