BookmarkSubscribeRSS Feed
gzr2mz39
Quartz | Level 8

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.

3 REPLIES 3
Reeza
Super User

Something along the lines of the following should work:

time_num=input(char_time, time12.);

format time_num time.;

gzr2mz39
Quartz | Level 8

This works. Thank you.

Patrick
Opal | Level 21

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.

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 9984 views
  • 3 likes
  • 3 in conversation