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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.