topic Re: Considering leap days. in SAS Programming

Considering leap days.

deleted_user — Mon, 08 Nov 2010 10:40:22 GMT

My code:

data dates;
start='20040228'
tmpstart=input(start,yymmdd8.)+364;
end=put(tmpstart,yymmddn8.);
run;

Result: end='20050226'. That's what I want, since the start was the next to last day in february.

start='20040229' gives end='20050227'. OK!
start='20040301' gives end='20050228'. OK!

But: start='20030301' gives end ='20040228'. I want end='20040229'.

Is there some time function that gives start + one calendar year - 1 day?

Re: Considering leap days.

Oleg_L — Mon, 08 Nov 2010 12:17:57 GMT

Hi
Use INTNX:

[pre]
data _null_;
start='20030301';
end=put(intnx('year',input(start,yymmdd8.),+1,'sameday')-1,yymmddn8.);
put start= end=;
run;
[/pre]

Re: Considering leap days.

darrylovia — Mon, 08 Nov 2010 12:56:17 GMT

I would suggest one of the Date Time Functions in SAS such as INTNX.

Google: SAS Date Functions
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a000245860.htm

Below is an example;

data dates;
length start $8;
input start $;
datalines;
20040228
20040229
20040301
20030301
;
run;

data one;
set dates;

tmpstart=input(start,yymmdd8.)+364;
end=put(tmpstart,yymmddn8.);

new_end=intnx('year',input(start,yymmdd8.),1,'sameday' )-1;
format new_end yymmdd10.;

put _all_;
run;