topic join two table in SAS Procedures

join two table

sasphd — Mon, 24 Nov 2014 15:01:28 GMT

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

Re: join two table

Loko — Mon, 24 Nov 2014 15:08:54 GMT

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;

Re: join two table

RW9 — Mon, 24 Nov 2014 15:12:06 GMT

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.