join two table

[sasphd]

Hello,

I have two to join

table 1

A     B

1     6

2     8

TABLE2

A     B

3     5

4     6

I want

A     B

1     6

2     8

3     5

4     6

[ballardw · Accepted solution]

data want;

     set

          table1

          table2

     ;

run;

You can have many sets appended this way. You can also use lists such as:

data want

     set table: ;

run;

The : says "Use all datasets in the library that start with Table". The order might not be what you want as TableAmuchlongername would come before TableB.