15 Minute Increment

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

15 Minute Increment


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


Accepted Solutions
Solution
‎05-09-2014 03:47 PM
Trusted Advisor
Posts: 1,607

Re: 15 Minute Increment

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;

View solution in original post


All Replies
Solution
‎05-09-2014 03:47 PM
Trusted Advisor
Posts: 1,607

Re: 15 Minute Increment

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;

Contributor
Posts: 33

Re: 15 Minute Increment

Thanks Paige!  I can work with this:-)

Super User
Posts: 9,662

Re: 15 Minute Increment

OR

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 324 views
  • 0 likes
  • 3 in conversation