INTNX by 15 Minute

BU2B — Thu, 12 Mar 2015 19:02:41 GMT

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.;

Re: INTNX by 15 Minute

sbb — Thu, 12 Mar 2015 19:12:48 GMT

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.

Re: INTNX by 15 Minute

Steelers_In_DC — Thu, 12 Mar 2015 19:27:49 GMT

You could use proc format:

1 - 14 = 15

16 - 29 = 30 etc.

Re: INTNX by 15 Minute

data_null__ — Thu, 12 Mar 2015 19:36:51 GMT

I think, based on your description, you want the Start of the next 15 minute interval.

page; 
data _null_; 
   do Starttime = datetime() by 15*60; 
      I + 1; 
      if i eq 20 then stop; 
      Min_Start = intnx('dtminute15',StartTime,1,'B');
      put (starttime min_start)(=datetime.);
      end; 
   run; 

33         data _null_;
34            do Starttime = datetime() by 15*60; 
35               I + 1; 
36               if i eq 20 then stop;
37               Min_Start = intnx('dtminute15',StartTime,1,'B');
38               put (starttime min_start)(=datetime.);
39               end;
40            run;

Starttime=12MAR15:12:34:38 Min_Start=12MAR15:12:45:00
Starttime=12MAR15:12:49:38 Min_Start=12MAR15:13:00:00
Starttime=12MAR15:13:04:38 Min_Start=12MAR15:13:15:00
Starttime=12MAR15:13:19:38 Min_Start=12MAR15:13:30:00
Starttime=12MAR15:13:34:38 Min_Start=12MAR15:13:45:00
Starttime=12MAR15:13:49:38 Min_Start=12MAR15:14:00:00
Starttime=12MAR15:14:04:38 Min_Start=12MAR15:14:15:00
Starttime=12MAR15:14:19:38 Min_Start=12MAR15:14:30:00
Starttime=12MAR15:14:34:38 Min_Start=12MAR15:14:45:00
Starttime=12MAR15:14:49:38 Min_Start=12MAR15:15:00:00
Starttime=12MAR15:15:04:38 Min_Start=12MAR15:15:15:00
Starttime=12MAR15:15:19:38 Min_Start=12MAR15:15:30:00
Starttime=12MAR15:15:34:38 Min_Start=12MAR15:15:45:00
Starttime=12MAR15:15:49:38 Min_Start=12MAR15:16:00:00
Starttime=12MAR15:16:04:38 Min_Start=12MAR15:16:15:00
Starttime=12MAR15:16:19:38 Min_Start=12MAR15:16:30:00
Starttime=12MAR15:16:34:38 Min_Start=12MAR15:16:45:00
Starttime=12MAR15:16:49:38 Min_Start=12MAR15:17:00:00
Starttime=12MAR15:17:04:38 Min_Start=12MAR15:17:15:00

topic Re: INTNX by 15 Minute in SAS Programming

INTNX by 15 Minute

Re: INTNX by 15 Minute

Re: INTNX by 15 Minute

Re: INTNX by 15 Minute