topic Merging data with variable dimension and repeatation in SAS Programming

Merging data with variable dimension and repeatation

desireatem — Fri, 27 Dec 2013 00:07:27 GMT

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

DATA A;

input id p;

cards;

1 2

2 3

3 7

4 9

;

Data B;

input id t;

cards;

1 3

2 4

;

to obtain;

data c;

input id p t;

cards;

1 2 3

2 3 4

3 7 .

4 9 .

Re: Merging data with variable dimension and repeatation

art297 — Fri, 27 Dec 2013 00:55:01 GMT

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

data c;

merge a b;

by id;

run;

Re: Merging data with variable dimension and repeatation

Jagadishkatam — Fri, 27 Dec 2013 00:56:11 GMT

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

Re: Merging data with variable dimension and repeatation

desireatem — Fri, 27 Dec 2013 01:03:42 GMT

Thanks