DATA Step, Macro, Functions and more

converting times from character to 24-hour

Reply
Regular Contributor
Posts: 196

converting times from character to 24-hour

I have times that are character fields in the format x:xx PM/AM, for example, 1:30 PM and 10:30 AM.

How can I convert these character fields into numeric fields that display 24-hour time? For example, change 1:00 PM to 13:00.

Super User
Posts: 17,819

Re: converting times from character to 24-hour

Something along the lines of the following should work:

time_num=input(char_time, time12.);

format time_num time.;

Regular Contributor
Posts: 196

Re: converting times from character to 24-hour

This works. Thank you.

Respected Advisor
Posts: 3,890

Re: converting times from character to 24-hour

You use a SAS INFORMAT to convert a character string to a SAS date or time or datetime value SAS(R) 9.3 Formats and Informats: Reference

You then apply a SAS FORMAT to this SAS date/time/datetime value so that it prints the way you want to.

Ask a Question
Discussion stats
  • 3 replies
  • 3537 views
  • 1 like
  • 3 in conversation