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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.