having some problem calculating time intervals

[rykwong]

Hi SAS community, I am trying to work with this variable (please see screenshot) which SAS is treating as a "datetime16."  I would like to create a separate date variable that has a format of "01JAN22" and a time variable of "07:26:27".  many thanks 

rykwong_0-1677092022109.png

[PaigeMiller]

You don't need a new variable for the date. Just assign the format DTDATE7. to this variable. If you want a time variable, use the TIMEPART function.

[Reeza · Accepted solution]

dateVar = datepart(seriesTimeStamp);
format datevar date9.;
timeVar = timepart(seriesTimeStamp);
format timeVar time8.;

TIMEPART and DATEPART to extract the date/time components of a datetime variable. 

[rykwong]

thanks so much!