topic Hour minutes informat in SAS Programming

Hour minutes informat

buddha_d — Wed, 26 Jul 2017 02:39:32 GMT

SAS gurus,
How can I read time (0233 or 1433) in sas?
HHMM. Is not working and I would like to see 24hrminute format
Have 0233 This is am
0233 This is pm

Want 0233
1433

Re: Hour minutes informat

Kurt_Bremser — Wed, 26 Jul 2017 05:41:38 GMT

Adapt the number so that it fits the time. informat, and use the index() function to determine pm and am. Set the hour either by adding 12*360, or use the intnx() function:

data want;
input timestr $25.;
time_num = input(substr(timestr,1,2) !! ':' !! substr(timestr,3,2),time5.);
if index(timestr,'pm') > 0 then time_num = intnx('hour',time_num,12,'s');
format time_num time8.;
cards;
0233 This is am
0233 This is pm
;
run;

Re: Hour minutes informat

buddha_d — Wed, 26 Jul 2017 09:51:52 GMT

Thanks KurtBremser, it works.