BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
IanW
Calcite | Level 5
Hi, trying to input a time formated
Hhmmsstt
What time input would i use
1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

What do the T's represent?
Why don't you just ignore them?

data test;
  string='13010240';
  time=input(string,hhmmss6.);
  put time= time=time12.3;
run;
619  data test;
620    string='13010240';
621    time=input(string,hhmmss6.);
622    put time= time=time12.3;
623  run;

time=46862 time=13:01:02.000

If they mean 100's of a second then read them separately.

 

634  data test;
635    string='13010240';
636    time=input(string,hhmmss6.)+input(substr(string,7),2.2);
637    put time= time=time12.3;
638  run;

time=46862.4 time=13:01:02.400

 

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

What do the T's represent?
Why don't you just ignore them?

data test;
  string='13010240';
  time=input(string,hhmmss6.);
  put time= time=time12.3;
run;
619  data test;
620    string='13010240';
621    time=input(string,hhmmss6.);
622    put time= time=time12.3;
623  run;

time=46862 time=13:01:02.000

If they mean 100's of a second then read them separately.

 

634  data test;
635    string='13010240';
636    time=input(string,hhmmss6.)+input(substr(string,7),2.2);
637    put time= time=time12.3;
638  run;

time=46862.4 time=13:01:02.400

 

IanW
Calcite | Level 5
Thanks I ended up using B8601TM

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 431 views
  • 0 likes
  • 2 in conversation