topic Re: Time format in SAS Programming

Time format

PrinceAde — Sun, 06 Oct 2024 18:10:43 GMT

Hi everyone, I have challenge formating time.
I'm trying to create time format from time().
For example, I want it in 5:25(I don't want pm or am attached to time). What I'm getting is either 5:25pm and 17:25.
data _null_;

call symputx('time', put(time, tod5.));

run;

%put &=time;

I have tried using time5. timeampm. as well.
None is working.
What can I do please?

Re: Time format

Kurt_Bremser — Sun, 06 Oct 2024 19:06:32 GMT

Roll your own picture format with '%0I:%0M' (%I displays hour in 12-hour format).

Re: Time format

Tom — Mon, 07 Oct 2024 00:26:27 GMT

Since you seem to be putting the value into a macro variable just add more logic.

Either after you have converted the time into a string.

1    data _null_;
2      time='17:25't ;
3      call symputx('time', substr(put(time, timeampm.),1,5));
4    run;

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


5    %put &=time;
TIME=5:25
6

Or before

7    data _null_;
8      time='17:25't ;
9      call symputx('time', put(mod(time,'12:00:00't), time5.));
10   run;

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


11   %put &=time;
TIME=5:25