topic Re: One to Many Merge in SAS Programming

One to Many Merge

NickA1 — Mon, 15 Jul 2019 19:17:05 GMT

Hi,

How can I do a one to many merge? I have included some sample data.

Data Set 1

ID Code

1 10

2 10

3 15

4 15

5 30

Data Set 2

ID Date

1 1/2/2019

1 1/3/2019

1 1/4/2019

3 1/2/2019

3 1/3/2019

3 1/4/2019

2 1/2/2019

2 1/3/2019

2 1/4/2019

4 1/2/2019

4 1/3/2019

4 1/4/2019

5 1/2/2019

5 1/3/2019

5 1/4/2019

Data Set I want:

ID Date Code

1 1/2/2019 10

1 1/3/2019 10

1 1/4/2019 10

3 1/2/2019 15

3 1/3/2019 15

3 1/4/2019 15

2 1/2/2019 10

2 1/3/2019 10

2 1/4/2019 10

4 1/2/2019 15

4 1/3/2019 15

4 1/4/2019 15

5 1/2/2019 30

5 1/3/2019 30

5 1/4/2019 30

Re: One to Many Merge

novinosrin — Mon, 15 Jul 2019 19:20:42 GMT

Already sorted by ID date?if yes

data want;

merge one two

by id;

run;

if not, then sort and use the above code

Re: One to Many Merge

Shmuel — Mon, 15 Jul 2019 19:21:19 GMT

Assuming both data are sorted by ID the most efficient way will be by:

data want;
merge data1 data2;
  by id;
run;

Re: One to Many Merge

NickA1 — Mon, 15 Jul 2019 19:50:44 GMT

proc sort data=Info2; by cusip; run;
proc sort data=Yieldsrenamed; by cusip; run;
data Merged;
merge Info2 Yieldsrenamed;
by cusip;
run;

Re: One to Many Merge

Reeza — Mon, 15 Jul 2019 20:47:48 GMT

Please mark the question solved be selecting the appropriate answer.