|
On Wed, 27 Apr 2005 11:36:16 -0700, nevin.krishna@GMAIL.COM wrote:
>Hi one follow up question,
>
>I used the code you suggested and it worked great..now i am trying to
>add another column to include another year of data..
>please see the following code, when i run it, it correctly creates two
>variables,and the data for year 2005 is correct, but the 2004 column
>does not dispaly data until line 366..
>morevover, it 2006 data is now appended to the 2005 column after line
>366..How do i display just 2004 and 2005 side by side..(so that there
>are only 365 obs)? Hope this is not too confusing...thanks again for
>your help..Nevin
>
>
> data comp_date;
> do date05 = '01jan2005'd to '31dec2005'd;
> output;
> end;
> do date04 ='01jan2004'd to '31dec2004'd;
> output;
> end;
> format date05 date04 date7.;
>run;
/* create 365 observations
date04 ranges from '01jan2004'd to '30dec2004'd
date05 ranges from '01jan2005'd to '31dec2005'd
*/
data comp_date;
drop _delta;
do _delta = 1 to 365;
date04 = '31dec2003'd + _delta;
date05 = '31dec2004'd + _delta;
output;
end;
format date04 date05 date7.;
run;
/* check */
proc print data=comp_date;
run;
/* on lst -- parts
Obs date04 date05
1 01JAN04 01JAN05
2 02JAN04 02JAN05
3 03JAN04 03JAN05
...
362 27DEC04 28DEC05
363 28DEC04 29DEC05
364 29DEC04 30DEC05
365 30DEC04 31DEC05
*/
| 
