Merging data with variable dimension and repeatation

[desireatem]

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   .

[art297 · Accepted solution]

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

data c;

  merge a b;

  by id;

run;

[desireatem]

Thanks

[Jagadishkatam]

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