Help using Base SAS procedures

How to convert time to 24 hr format

Reply
Frequent Contributor
Posts: 114

How to convert time to 24 hr format

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
Trusted Advisor
Posts: 1,837

Re: How to convert time to 24 hr format

[ Edited ]

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.

Frequent Contributor
Posts: 114

Re: How to convert time to 24 hr format

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
Trusted Advisor
Posts: 1,837

Re: How to convert time to 24 hr format

[ Edited ]

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

 

 

Frequent Contributor
Posts: 114

Re: How to convert time to 24 hr format

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
Trusted Advisor
Posts: 1,837

Re: How to convert time to 24 hr format

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.

Ask a Question
Discussion stats
  • 5 replies
  • 430 views
  • 2 likes
  • 2 in conversation