BookmarkSubscribeRSS Feed
Allan_dk
Quartz | Level 8

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?


1 REPLY 1
mariusg
Obsidian | Level 7

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1756 views
  • 0 likes
  • 2 in conversation