topic Re: Increasing time intervals by seconds in New SAS User

Increasing time intervals by seconds

D_W — Sun, 18 Nov 2018 02:00:31 GMT

Hi, I currently have a table with a list of time intervals that aren't always continuous such as the first observation being 9:35:10- 9:35:20 and the second observation being 9:35:50- 9:36:00. I would like to create a new variable that adds seconds to each observation, for instance:

Obs. Time_interval New_interval

1 9:35:10- 9:35:20 9:35:20- 9:35:30

2 9:35:50- 9:36:00 9:36:00- 9:36:10

3 9:36:10- 9:36:20 9:36:20- 9:36:30

I've tried using an INTNX function to create the new variable. The code runs but no there are no observations. Any suggestions would be greatly appreciated, thanks. Here is a sample of code I've tried:

data temp; set temp;
New_interval = intnx('ss',time_interval,10);
run;

Re: Increasing time intervals by seconds

Reeza — Sun, 18 Nov 2018 02:25:10 GMT

INTNX will work on a date, datetime or time variable. My guess is that’s a character variable. If that’s the case, separate the times and then try INTNX again. Though time is stored in seconds so basic math and the ROUND/FLOOR/CEIL functions may be enough.

Re: Increasing time intervals by seconds

PGStats — Sun, 18 Nov 2018 06:49:58 GMT

Doing this the formal way:

data temp;
time_interval = "9:35:10- 9:35:20";
interval_start = input(scan(time_interval, 1, "-"), time8.);
interval_end = input(scan(time_interval, 2, "-"), time8.);
new_interval_start = intnx("second", interval_start, 10);
new_interval_end = intnx("second", interval_end, 10);
format interval_start interval_end new_interval_start new_interval_end time8.;
New_interval = catt(  
    put(new_interval_start, time8.), 
    "-",
    put(new_interval_end, time8.) );
run;