@BCNAV wrote:
A couple of small issues:
1. I have a datetime26.7 variable (flightdatetime) that has values like: 26SEP2018:00:51:48.0000000
I need to create a new one that truncates the seconds....so I would have: 26SEP2018:00:51 as a datetime variable (no seconds)
Example using INTX to round to minutes:
data example;
x='26SEP2018:00:51:48.0000000'dt;
y=intnx('minute',x,0,'B');
format x y datetime26.7;
run;
to do similar with a character value adding 51 minutes:
data example;
x='26SEP2018:00:00:0.0000000';
y=put (intnx('minute',input(x,datetime27.7),51,'B'), datetime27.7);
run;
use the appropriate format/informat for your need.
... View more
