merge no nulls

[tmm]

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

[LinusH]

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.

[Astounding · Accepted solution]

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.

[shivas]

Hi,

Try this...

data want;

set one;set two;

run;

data want1;

merge one two;

run;

Thanks,

Shiva