Write and run SAS programs in your web browser

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

Reply
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: 11,771

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

Posted in reply to harshronaldo

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: 7,633

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

Posted in reply to harshronaldo

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: 11,771

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
Ask a Question
Discussion stats
  • 3 replies
  • 234 views
  • 2 likes
  • 3 in conversation