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;