topic Re: Time conversion in SAS Procedures

Time conversion

Asger — Tue, 18 Sep 2018 07:16:55 GMT

Hi.

In my data file I have a variable containing time consumption (hours:minutes; not a time of day). It is saved in the "time"-format. Using the Summary Statistics Wizard in SAS Enterprise Guide I end up with integers and not the original format of time.

How can I change this so I end up with a summary statistics of time?

See attached file.

All the best,

Asger

Re: Time conversion

andreas_lds — Tue, 18 Sep 2018 11:44:02 GMT

The time-format in sas is always the number of seconds since midnight. Please post your data using a data-step with datalines statement, office-files aren't helpful to show data.

Re: Time conversion

Asger — Tue, 18 Sep 2018 13:12:12 GMT

Thank you for the response. My input is hours and minutes between to dates and times; it is not a time of day. So I don´t think the number of seconds since midnight can be used here.

This is the autogenerated code from Enterprise Guide:

PROC MEANS DATA=WORK.SORTTempTableSorted

FW=12

PRINTALLTYPES

CHARTYPE

QMETHOD=OS

MIN

MAX

MEDIAN

Q3 ;

VAR "Tid diff1"n;

RUN;

Was that what you were looking for Andreas?

Re: Time conversion

Tom — Tue, 18 Sep 2018 14:18:17 GMT

Means will not try to use formats in that simple display. If you want to attach a format then write your statistics to a dataset and print that.

Then you can attach formats to the values.

data x ;
  input y time5. ;
  format y time5. ;
cards;
10:30
11:30
;
proc summary ;
 var y;
 output out=want mean=mean_y min=min_y max=max_y ;
run;
proc print data=want;
  var m:;
  format m: hhmm. ;
run;