Join Tables

Reply
N/A
Posts: 1

Join Tables

Hello,

I have these 2 tables :

TABLE1

1 A

1 F

2 B

3 C

4 D

TABLE 2

1 Z

1 E

2 DF

3 SE

and i want these results :

1 A Z

1 F E

2 B D F

Have you ideas ?

Grand Advisor
Posts: 10,210

Re: Join Tables

What is the rule for dropping observations 4 and 5 from table1 and observation 4 from table 2?

Also assume that your 2 B D F was supposed to be 2 B DF.

Variable names would be nice.

Something like:

data want;

     merge table1 table2(drop=FirstColumn);

run;

matches observations but not on any values.

Ask a Question
Discussion stats
  • 1 reply
  • 154 views
  • 0 likes
  • 2 in conversation