topic Re: 15 Minute Increment in SAS Programming

15 Minute Increment

BU2B — Fri, 09 May 2014 18:56:06 GMT

Hi all,

I need to populate a column in a data set that starts at midnight '00:00't and increments in 15 minute intervals. 00:00, 00:15, 00:30, 00:45 out to 23:45. I've been working with INTNX but all I get is a repeated time of 00:15. What am I doing wrong? Thanks!

data work.rtspp_with_time;

set work.rtspp;

INTDATE = intnx('dtminute', '00:00:00't, 15);

format INTDATE HHMM.;

run;

Steve

Re: 15 Minute Increment

PaigeMiller — Fri, 09 May 2014 19:47:02 GMT

You need a loop

For example: (Untested code), where the value of "something" is an integer left as a homework assignment for you to figure out

data work.rtspp_with_time;

do loop=15 to something by 15;
INTDATE = intnx('dtminute', '00:00:00't, loop); output;
end;
format INTDATE HHMM.;

run;

Re: 15 Minute Increment

BU2B — Fri, 09 May 2014 20:20:36 GMT

Thanks Paige! I can work with this:-)

Re: 15 Minute Increment

Ksharp — Sat, 10 May 2014 04:10:23 GMT

do time='00:00:00't to '24:00:00't by 15*60 ;