topic merge no nulls in SAS Procedures

merge no nulls

tmm — Wed, 14 Mar 2012 12:12:36 GMT

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

merge no nulls

LinusH — Wed, 14 Mar 2012 12:17:53 GMT

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.

merge no nulls

Astounding — Wed, 14 Mar 2012 12:20:22 GMT

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.

merge no nulls

shivas — Wed, 14 Mar 2012 12:24:10 GMT

Hi,

Try this...

data want;

set one;set two;

run;

data want1;

merge one two;

run;

Thanks,

Shiva