Merging data with variable dimension and repeatation

Accepted Solution Solved
Reply
Super Contributor
Posts: 297
Accepted Solution

Merging data with variable dimension and repeatation

How can I merge data A and data B below to obtain C  by ID;

DATA A;

input id p;

cards;

1    2

1     2

2    3

3  7

4   9

4   9

;

Data B;

input id t;

cards;

1   3

2   4

;

to obtain;

data c;

input id p t;

cards;

1    2   3

1   2    3

2   3    4

3  7    .

4   9    .

4   9   .


Accepted Solutions
Solution
‎12-26-2013 07:55 PM
PROC Star
Posts: 7,356

Re: Merging data with variable dimension and repeatation

As long as you don't have duplicate IDs in B, then you could just use:

data c;

  merge a b;

  by id;

run;

View solution in original post


All Replies
Solution
‎12-26-2013 07:55 PM
PROC Star
Posts: 7,356

Re: Merging data with variable dimension and repeatation

As long as you don't have duplicate IDs in B, then you could just use:

data c;

  merge a b;

  by id;

run;

Super Contributor
Posts: 297

Re: Merging data with variable dimension and repeatation

Thanks

Trusted Advisor
Posts: 1,128

Re: Merging data with variable dimension and repeatation

Please try,

PROC SQL;

   CREATE TABLE A_B AS

   SELECT t2.t,

          t1.id,

          t1.p

      FROM WORK.A t1

           FULL JOIN WORK.B t2 ON (t1.id = t2.id);

QUIT;

Alternatively in datastep

data A_B;

  merge a(in=a) b(in=b);

  by id;

run;

Thanks,

Jag

Thanks,
Jag
☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 178 views
  • 3 likes
  • 3 in conversation