join two table

[sasphd]

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

[Loko · Accepted solution]

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;

[RW9]

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.