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
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
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!
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.
Ready to level-up your skills? Choose your own adventure.