Help using Base SAS procedures

join two table

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

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: 308

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;

View solution in original post


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

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
Super User
Posts: 7,975

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.

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

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