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
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;
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;
Thanks Paige! I can work with this:-)
OR
do time='00:00:00't to '24:00:00't by 15*60 ;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.