Hi, I have time in HHMMSSS and would like to informat and format it with (eg 12:23:123) in SAS dataset.
I used time7. for informat, but returns with "." in the SAS dataset.. Could you please help me how to do that ? Thanks you so much.
data have;
input hhmmsss;
datalines;
1223123
0403267
;
run;
I used the picture format to get the result.
proc format;
picture times (default=10) low-high="99:99:990";
run;
data have;
input hhmmsss;
time=put(hhmmsss,times.);
datalines;
1223123
0403267
;
run;
Thanks,
Jag
And you are having problems because your data as written is indicating more that 60 seconds to a minute.
You may want to get the fractional seconds using a different informat if want an actual time value:
data have;
informat hhmmsss b8601tm7.1;
input hhmmsss ;
format hhmmsss time12.1;
datalines;
1223123
0403267
;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.