topic Re: create duplicates between two years in SAS Programming

create duplicates between two years

AmirSari — Sat, 16 Oct 2021 06:12:26 GMT

Hi everyone,

This seems like a simple problem but I can't figure it out. I want to repeat rows between two years by group.

here is a sample of my data:

data have;
 input id name $ role $ year1 year2; 
datalines;
1 Jon CEO 2000 2004
2 Mike President 2006 2008
3 George Advisor 2010 2010
;

And here is what I am looking for.

id	name	role	year1	year2	year3
1	Jon	CEO	2000	2004	2000
1	Jon	CEO	2000	2004	2001
1	Jon	CEO	2000	2004	2002
1	Jon	CEO	2000	2004	2003
1	Jon	CEO	2000	2004	2004
2	Mike	President	2006	2008	2006
2	Mike	President	2006	2008	2007
2	Mike	President	2006	2008	2008
3	George	Advisor	2010	2010	2010

Thank you!

Re: create duplicates between two years

PeterClemmensen — Sat, 16 Oct 2021 07:33:01 GMT

Try this 🙂

data have;
 input id name $ role $ year1 year2; 
datalines;
1 Jon CEO 2000 2004
2 Mike President 2006 2008
3 George Advisor 2010 2010
;

data want;
   set have;
   do year3 = year1 to year2;
      output;
   end;
run;

Re: create duplicates between two years

AmirSari — Sat, 16 Oct 2021 17:22:52 GMT

Thank you!

Re: create duplicates between two years

PeterClemmensen — Sat, 16 Oct 2021 18:59:10 GMT

Anytime