join tables

[sasphd]

Hello,

I want to joint some tables.

table 1

A     B     C

1     2     5    

2     9     6

5     5     6

table2

A     B     C

8     9     9    

5     6     3    

2     1     3    

JOINT TABLE THAT I WANT

A     B     C

1     2     5    

2     9     6

5     5     6

8     9     9    

5     6     3    

2     1     3

[stat_sas · Accepted solution]

data want;

set table1 table2;

run;

[PGStats]

Join is reserved for something else. What you want is concatenate:

data join;

set table1 table2;

run;

PG

[Ksharp]

select * from table1

union all

select * from table2