Time conversion

[Asger]

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

[andreas_lds]

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.

[Asger]

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

N

Q1

MEDIAN

Q3 ;

VAR "Tid diff1"n;

RUN;

Was that what you were looking for Andreas?

[Tom]

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;