## Merging data with variable dimension and repeatation

Solved
Super Contributor
Posts: 328

# 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: 8,165

## 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;

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

## 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: 328

Thanks

Posts: 1,147

## Re: Merging data with variable dimension and repeatation

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 and locked.