topic Re: How to convert time to 24 hr format in SAS Procedures

How to convert time to 24 hr format

Gil_ — Tue, 15 Aug 2017 15:18:17 GMT

Hi I have a datetime field open date
08/01/2017 1;42;00 PM
I need to convert the date to
08/01/2017 13:42 PM

Thanks

Re: How to convert time to 24 hr format

Shmuel — Tue, 15 Aug 2017 15:45:37 GMT

Change format from DATEAMPMw. to DATETIMEw. where w is length of output dislaying date and time.

If time is 13:42 there is no need to add PM.

Re: How to convert time to 24 hr format

Gil_ — Tue, 15 Aug 2017 21:18:10 GMT

Hi Shmuel.
Thanks for response...how do I apply it I'm using a
Data table1;
Set table1;
Time =timepart (open _date);
Format time datetime.;
Run;

It gives 01jan1960 05:49:53 the time is still at general time

Re: How to convert time to 24 hr format

Shmuel — Tue, 15 Aug 2017 22:41:09 GMT

When you use function TIMEPART you have time only, without the date.

format DATETIME is to be used with your variable Open_Date.

Use format time5. or time7. for TIME (as timepart).

Data table1;
Set table1;
Time =timepart (open _date);
Format open_date datetime. 
            time    time7.;
Run;

Look at next link - formats by categories:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001263753.htm

Re: How to convert time to 24 hr format

Gil_ — Wed, 16 Aug 2017 16:38:30 GMT

Thanks for the example it did 2 things it convert all my dates to 01jan6005:49:53. So the column of time it does give me the right format but the time is 5:49:53 should be 04:49:53 .. I'm using your data set .. thanks

Re: How to convert time to 24 hr format

Shmuel — Wed, 16 Aug 2017 17:52:16 GMT

You compute

Time =timepart (open_date);

which gives you a date of 01jan60 - this turns a red light, maybe your variable Open_Date is not a datetime but a time only.

In sas 0 (zero) is equal to Jan 1st 1960.

Try do:

Data _NULL_;
set have;
 put open_date  time9.;
run;

and check the log.