Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Calculate Median

Reply
Contributor
Posts: 40

Calculate Median

I have some data where the mean (average) will give the wrong impression of the data, because of some few high values. Instead I will like to calculate the median.

How can I do that and display it in a crosstab?


Contributor
Posts: 38

Re: Calculate Median

Hey Allan,

normally we use a simple boxplot to calculate the median and other numbers.

I don`t really have a solution to calculate the median on the fly within a crosstab, like avg,min, max etc.

But maybe this will be an acceptable workaround for you?

1. Build a Data Query with simple proc sql

........

.......

proc sql noprint;

  create view TEMP_LASR_VIEW_0 as

    SELECT

        CARS5.Type length=6 format=$6. AS Type,

        median(CARS5.Horsepower) length=8 format=BEST12. AS Horsepower

    FROM

        LASRLIB.CARS5 CARS5

   GROUP BY

       Type ;

.......

......

(Or use proc means with output out=...)

2. Use the table in your report

Bildschirmfoto 2014-06-06 um 09.49.56.png

Performance will maybe be a problem.

You have to type median into the expression field, because in the default functionlist there isn`t median.

kind regards

Marius

Ask a Question
Discussion stats
  • 1 reply
  • 574 views
  • 0 likes
  • 2 in conversation