how to calculate mean of time which is in a format of HHMM.?

[harshronaldo]

Hi ,

i am not able to calculate mean of time which is in a format of HHMM.? when i am using proc mean it giving me  the output in numeric value but i wanted the output only HHMM. format only .

[ballardw]

Proc mean statistics do not inherit the formats of the base variables. So either send the output to a data set and assign the desired format or use a different reporting procedure that allows specifying the format in the displayed output such as Proc Tabulate or Proc Report

[art297]

Use proc template to have proc means output the means using the time5. format. e.g.:

data have;
  input time time5.;
  cards;
9:30
10:30
11:30
;

ods path(prepend) work.templat(update);
proc template;
 edit base.summary;
  edit mean;
   format=time5.;
  end;
 end;
run;
 
proc means data=have mean;
  var time;
run;
 
/* restore default template */
proc template;
 delete base.summary;
run;

Art, CEO, AnalystFinder.com

[ballardw]

---

@art297 wrote:

Use proc template to have proc means output the means using the time5. format. e.g.:

Art, CEO, AnalystFinder.com

---

@art297 We'll hope the OP wasn't requesting statistics for any other variables with the template approach. Though I do find the idea of a mean height of 0:02:45 cm very entertaining...

Using that template:

proc means data=sashelp.cars mean;
  var msrp horsepower ;
run;

The MEANS Procedure

Variable       Mean

MSRP           9:06
Horsepower     0:03