topic Re: having some problem calculating time intervals in SAS Programming

having some problem calculating time intervals

rykwong — Wed, 22 Feb 2023 18:55:35 GMT

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

Re: having some problem calculating time intervals

PaigeMiller — Wed, 22 Feb 2023 19:01:53 GMT

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.

Re: having some problem calculating time intervals

Reeza — Wed, 22 Feb 2023 19:04:38 GMT

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.

Re: having some problem calculating time intervals

rykwong — Wed, 22 Feb 2023 22:47:04 GMT

thanks so much!