topic Re: Data Manipulation in SAS Data Management

Data Manipulation

katie80 — Mon, 05 Oct 2015 14:50:23 GMT

HI, I have a large database that needs to be manipulated. I want to convert the data that looks like this:

id	date1	date2	var1	var2
1	2005	2008	5	3
2	2006	2008	1	2

to something that looks like this:

id	date1	date2	date3	var1	var2
1	2005	2008	2005	5	3
1	2005	2008	2006	5	3
1	2005	2008	2007	5	3
1	2005	2008	2008	5	3
2	2006	2008	2006	1	2
2	2006	2008	2007	1	2
2	2006	2008	2008	1	2

Basically, I want to convert each observation into id-years.

what is the best and most efficient way to do this?

Thanks!

Re: Data Manipulation

ballardw — Mon, 05 Oct 2015 14:52:57 GMT

If I understand what you are attempting;

Data want;
   set have;
   do date3 = date1 to date2;
        output;
   end;
run;

Re: Data Manipulation

katie80 — Mon, 05 Oct 2015 14:59:10 GMT

Thank you! I'll try that!

Re: Data Manipulation

Jim_G — Thu, 22 Oct 2015 13:34:53 GMT

data one;
input id: date1: date2: var1: var2:;
dur=date2-date1+1; date3=date1;
do x=1 to dur;
output;
date3+1;
end;
cards;
1 2005 2008 5 3
2 2006 2008 1 2
;
proc print; run;