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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.