Help using Base SAS procedures

join tables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

join tables

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


Accepted Solutions
Solution
‎08-19-2014 04:16 PM
Trusted Advisor
Posts: 1,204

Re: join tables

data want;

set table1 table2;

run;

View solution in original post


All Replies
Solution
‎08-19-2014 04:16 PM
Trusted Advisor
Posts: 1,204

Re: join tables

data want;

set table1 table2;

run;

Respected Advisor
Posts: 4,640

Re: join tables

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

data join;

set table1 table2;

run;

PG

PG
Super User
Posts: 9,662

Re: join tables

select * from table1

union all

select * from table2

☑ This topic is SOLVED.

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

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