topic Re: join two table in SAS Procedures

join two table

sasphd — Mon, 20 Apr 2015 18:42:14 GMT

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

Re: join two table

ballardw — Mon, 20 Apr 2015 20:45:25 GMT

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.