Can anyone help me to figure out the code that can change a time variable in SAS from HH : MM : SS.SS to HHMM?
like 20:35:00.00 to 2035
Thanks very much!
I don't think there's a format, but you can easily create your own using proc format.
proc format;
picture mytime other='%0H%0M' (datatype=time);
run;
Thanks for your answer.
I figured it out just now and it works for my assignment.
Here is the code:
data time;
set Slice;
OrderTimeNewPart1=substrn(OrderTime,1,2);
OrderTimeNewPart2=substrn(OrderTime,4,2);
OrderTimeNewPart=trim(OrderTimeNewPart1)||OrderTimeNewPart2;
OrderTimeNew=prxchange('s/^0+//o',-1,OrderTimeNewPart);
drop OrderTimeNewPart1 OrderTimeNewPart2 OrderTimeNewPart;
run;
Your variable is now text. Depending on what you want that may be fine, but in general I find it easier to keep them as date/time/datetime for analysis and calculations later on.
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.