proc - SAS: Mean, median, max and percentiles by two variables

Question

I have a dataset structured with 5 columns. Month, User, Num1, Num2, Num3.

I'm trying to calculate, for each Num1 Num2 and Num3, the mean, median, max, 25th and 75th percentile for each permutation of Month and User.

I have tried proc univariate but I can't do it without creating a macro and manual steps for each Month and User permutation.

My ideal output would then look like this, and separate outputs for Num1 Num2 Num3: http://i.imgur.com/YC67LV1.png

Thanks!

Answer 1

PROC Means does what you want.

Here is an example with the SASHELP.SHOES example dataset.

ods html;
proc means data=sashelp.shoes mean median max p25 p75;
   class region product;
   var sales inventory returns;
run;
ods html close;