Hi all,
One more question... I have a time field that I want to increment to the next 15 minute interval. So if the first obs is 00:36 I want 00:45, if 1:12 I want 1:15 etc. Here's what I have so far, but it advances to the next hour, not 1/4 hour...
Min_Start = intnx('dthour',StartTime,.25, 'e');
format Min_Start HHMM.;
I think, based on your description, you want the Start of the next 15 minute interval.
Reviewing the SAS LANGUAGE documentation, have a look at INTNX and the DTMINUTEnn function.
Suggested browser search argument: intnx function 15 minute interval site:sas.com
Scott Barry
SBBWorks, Inc.
You could use proc format:
1 - 14 = 15
16 - 29 = 30 etc.
I think, based on your description, you want the Start of the next 15 minute interval.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.