The attached dataset has time in 24 hour format, see below:
000257
000341
000419
000433
000437
000451
002538
002719
002903
003029
003135
003141
So 133846 indicates 1 pm 38 minutes 46 seconds. But the value is in string. How could I convert the TIME string into SAS time? I used the following code:
data WANG;
set HAVE;
time_numeric = input(time, time5.);
run;
But it doesn't seem to work. SAS reports:
NOTE: Invalid argument to function INPUT at line 24 column 8.
time=000257 timej=. _ERROR_=1 _N_=11
NOTE: Invalid argument to function INPUT at line 24 column 8.
time=000341 timej=. _ERROR_=1 _N_=12
Could you guys help me~~
Do this:
data wang;
set have;
format time_numeric time8.;
time_numeric = input(substr(time,1,2) !! ':' !! substr(time,3,2) !! ':' !! substr(time,5,2),time8.);
run;
Do this:
data wang;
set have;
format time_numeric time8.;
time_numeric = input(substr(time,1,2) !! ':' !! substr(time,3,2) !! ':' !! substr(time,5,2),time8.);
run;
Hi ,
Use time_numeric=input(time,hhmmss6.);
this should read your time.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.