topic Re: convert sas time5. format values to nominal values in SAS Programming

convert sas time5. format values to nominal values

ari — Wed, 24 Jan 2018 10:51:41 GMT

Hi ,

Is there an easy way to convert time values in time5. format into nominal time values.?

Example: 8:30 as 8.5

16:30 as 16.5

17:45 as 17.75

Re: convert sas time5. format values to nominal values

RW9 — Wed, 24 Jan 2018 11:10:32 GMT

One way:

data want;
  time="08:30"t;
  number=hour(time)+ ((10 / (60/minute(time)))/10);
  output;
  time="17:45"t;
  number=hour(time)+ ((10 / (60/minute(time)))/10);
  output;  
  format time time5.;
run;

Re: convert sas time5. format values to nominal values

Kurt_Bremser — Wed, 24 Jan 2018 11:42:47 GMT

Since time values are just counts of seconds, a simple division and rounding will do it:

data test;
input time time5.;
time_nom = round(time/3600,.01);
format
  time time5.
  time_nom 5.2
;
cards;
08:30
16:30
17:45
;
run;