topic Re: Report with percentiles ,mean,std calculations in SAS Programming

Report with percentiles ,mean,std calculations

Ronein — Tue, 30 Nov 2021 21:22:07 GMT

Hello

May anyone show a code that create this type of report.

Is it posible to do it via proc report in one step?

Is it posible to do it via proc tabulate in one step?

Is it posible to do it via proc univariate in one step?

thanks

Re: Report with percentiles ,mean,std calculations

PaigeMiller — Tue, 30 Nov 2021 21:24:25 GMT

Hello

By now, since you have been in the Communities for several years, you must know that many of us will not download attachments, and if you want to show us the desired output, show us a screen capture (but do not use screen captures for data or code or logs).

Re: Report with percentiles ,mean,std calculations

Ronein — Wed, 01 Dec 2021 05:25:55 GMT

Sure, please see here

Re: Report with percentiles ,mean,std calculations

Kurt_Bremser — Wed, 01 Dec 2021 08:18:35 GMT

Also please supply source data in usable form, so we know what we start with.

Re: Report with percentiles ,mean,std calculations

PaigeMiller — Wed, 01 Dec 2021 11:47:47 GMT

@Ronein wrote:

Sure, please see here

As a "thinking out of the box" solution, have you considered creating side-by-side box plots of these variables and geographic locations? A box plot shows the distribution (mean, standard deviation, upper and lower quartiles, median and p90) for each geographic region as a picture rather than a table, and would be very simple to produce, and is relatively easy to understand. Example

Re: Report with percentiles ,mean,std calculations

ballardw — Wed, 01 Dec 2021 16:35:59 GMT

Proc tabulate would not have the variable repeated on the rows, just once but

Proc tabulate data = have;
   class country;
   var height weight iq;
   table (height weight iq) *(mean std q1 median q3 p90 ),
            country
   ;
run;

Proc Report really dislikes multiple statistics in a single column and would require you do more coding.

Tabulate will not do all of the quantile statistics that proc means/summary and univariate can but does do many of the commonly used 1,5,10,20,30,...90, 95,99 plus the quartiles.

Re: Report with percentiles ,mean,std calculations

PaigeMiller — Fri, 17 Dec 2021 15:28:27 GMT

Why you should visualize distributions instead of report means - The DO Loop (sas.com)