Help using Base SAS procedures

merge no nulls

Accepted Solution Solved
Reply
Regular Contributor
Regular Contributor
Posts: 238
Accepted Solution

merge no nulls

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


Accepted Solutions
Solution
‎03-14-2012 08:20 AM
Super User
Posts: 5,516

merge no nulls

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.

View solution in original post


All Replies
Super User
Posts: 5,437

merge no nulls

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.

Data never sleeps
Solution
‎03-14-2012 08:20 AM
Super User
Posts: 5,516

merge no nulls

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.

Super Contributor
Posts: 349

merge no nulls

Hi,

Try this...

data want;

set one;set two;

run;

data want1;

merge one two;

run;

Thanks,

Shiva

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 159 views
  • 0 likes
  • 4 in conversation