BookmarkSubscribeRSS Feed
gnrslasher37
Fluorite | Level 6

I have time data in format of hh:mm:ss:nnn. How can i read the data with interval of a minute from that data where nano seconds are inclusive.

 

Thanks,

 

Gobin

4 REPLIES 4
Kurt_Bremser
Super User

Use the INTNX function to increment by 'minute'. Edit: with alignment 'same'!

If your value is still stored in a character variable, use the time12.3 informat for conversion before applying the intnx function.

gnrslasher37
Fluorite | Level 6
Thanks for the previous one. Further, is it possible to get the millisecond
value from hh:mm:ss.nnn time format in SAS. Actually i have the data that
differs on that milliseconds.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Kurt_Bremser
Super User

If you used the time12.3 as informat, your SAS time value will contain the milliseconds after the decimal point.

To extract only the milliseconds, do

milsecs = (timeval - int(timeval)) * 1000;
Sousa
Calcite | Level 5

@Kurt_Bremser Thank you very much!! This helped. Smiley Very Happy the key 'same'

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 4925 views
  • 2 likes
  • 3 in conversation