Report with percentiles ,mean,std calculations

[Ronein]

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

[PaigeMiller]

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).

[Ronein]

Sure, please see here

[PaigeMiller]

---

@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

[PaigeMiller]

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

[Kurt_Bremser]

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

[ballardw]

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.