Learner
Posts: 1

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

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 .

Super User
Posts: 13,066

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

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

PROC Star
Posts: 8,114

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

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

Highlighted
Super User
Posts: 13,066

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

[ Edited ]

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
```
Discussion stats
• 3 replies
• 285 views
• 2 likes
• 3 in conversation