## join two table

Solved
Frequent Contributor
Posts: 126

# join two table

I want to join two tables in this way

Table 1

A     B

2     3

6     5

Table 2

C     D

9     6

5     5

table want

A     B      C     D

2     3       9     6

6     5       5     5

Accepted Solutions
Solution
‎11-24-2014 10:08 AM
Super Contributor
Posts: 319

## Re: join two table

Hello,

data Table1;
input A B;
datalines;
2 3
6 5
;
data Table2;
input C D;
datalines;
9 6
5 5
;

data want;
merge Table1 Table2;
run;

All Replies
Solution
‎11-24-2014 10:08 AM
Super Contributor
Posts: 319

## Re: join two table

Hello,

data Table1;
input A B;
datalines;
2 3
6 5
;
data Table2;
input C D;
datalines;
9 6
5 5
;

data want;
merge Table1 Table2;
run;

Super User
Posts: 9,599

## Re: join two table

Well, Loko provides a solution, I would ask why however.  Merging data with no logical pattern doesn't seem to be beneficial in any way.  Each time you run it there is a possibility that you will get a different result.   So why should A=2, B=3 match to C=9 and D=6 rather than C=5 and D=5.

🔒 This topic is solved and locked.

Discussion stats
• 2 replies
• 205 views
• 0 likes
• 3 in conversation