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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.