So I have a column that looks like this:
data time;
input time $4.;
datalines;
0930
1000
0800
1300
1530
;
run;
and I want it to look like this:
09:30
10:00
08:00
13:00
15:30
Which is in a HHMM. or TIME. format
Tried the PUT statement and came back with an error
ERROR: The informat HHMM was not found or could not be loaded.
Is there any simple ways of doing this?
Thanks.
data time; input time $4.; time_calc=input(time,hhmmss4.); format time_calc time5.; datalines; 0930 1000 0800 1300 1530 ; run;
Maybe i am blind, but i don't see the mentioned put statement in your code.
Index of informats: https://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#n0verk17pch...
I suggest using "hhmmss" instead of "hhmm".
data time; input time $4.; time_calc=input(time,hhmmss4.); format time_calc time5.; datalines; 0930 1000 0800 1300 1530 ; run;
I could not find relevant format to read it direclty. But you can use below code to get desired result.
data time(keep=t1 time);
input time $4.;
t1=substr(time,1,2)*3600 +substr(time,3,2)*60 ;
format t1 time5.;
datalines;
0930
1000
0800
1300
1530
;
run;
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.