topic Re: A Quick question about SAS time from HH:MM:SS.SS to HHMM in SAS Programming

A Quick question about SAS time from HH:MM:SS.SS to HHMM

quanzhou22 — Mon, 26 Sep 2016 03:33:13 GMT

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!

Re: A Quick question about SAS time from HH:MM:SS.SS to HHMM

Reeza — Mon, 26 Sep 2016 03:30:15 GMT

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;

Re: A Quick question about SAS time from HH:MM:SS.SS to HHMM

quanzhou22 — Mon, 26 Sep 2016 04:33:30 GMT

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;

Re: A Quick question about SAS time from HH:MM:SS.SS to HHMM

Reeza — Mon, 26 Sep 2016 05:51:35 GMT

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.