topic Median in sas 9.3 in SAS Programming

Median in sas 9.3

don21 — Thu, 04 Jan 2018 16:30:25 GMT

Dear all,

I have created a ODS excel report with proc report, I have noticed in one of the excel outputs that one table should be reflecting the Median values instead of sum.. I tried changing this in the proc report statement:

define Numbers/group median style={tagattr='format:#,###'} center; /** changed sum to median**/ but it doesnt work.

I tried changing in the base data set in sas using proc sql query, still no use.

Request you to kindly suggest any syntax or anything.I am using SAS 9.3 currently..

Many thanks.

Re: Media in sas 9.3

RW9 — Thu, 04 Jan 2018 09:06:43 GMT

Its generally not a good idea to do processing in proc report, as that is a reporting function. Use proc means before that to get the data in the way you want then a simple proc report to output the data. Don't think report can even do the more complicated calculations.

proc means data=yourdata;
  by id;
  var thevar;
  output out=want median=median;
run;

Shows and example use of proc means (as you haven't shown any test data or code this is just an example).

Re: Media in sas 9.3

Kurt_Bremser — Thu, 04 Jan 2018 09:07:10 GMT

You can use statistics only on analysis variables. See the documentation for this:

statistic

associates a statistic with an analysis variable. You must associate a statistic with every analysis variable in its definition. PROC REPORT uses the statistic that you specify to calculate values for the analysis variable for the observations that are represented by each cell of the report. You cannot use statistic in the definition of any other type of variable.

(emphasize by me)

Re: Media in sas 9.3

Reeza — Thu, 04 Jan 2018 16:27:07 GMT

ODS EXCEL isn't supported in SAS 9.3

Are you using ODS TAGSETS.EXCELXP or something else?

@don21 wrote:

Dear all,

I have created a ODS excel report with proc report, I have noticed in one of the excel outputs that one table should be reflecting the Median values instead of sum.. I tried changing this in the proc report statement:

define Numbers/group median style={tagattr='format:#,###'} center; /** changed sum to median**/ but it doesnt work.

I tried changing in the base data set in sas using proc sql query, still no use.

Request you to kindly suggest any syntax or anything.I am using SAS 9.3 currently..

Many thanks.

Re: Media in sas 9.3

don21 — Wed, 14 Feb 2018 04:38:19 GMT

I have ungrouped my sas dataset and used it again for median under ODS proc reports, and it is working now. 🙂