Saving Percentiles in an Output Data Set

[sasphd]

hello,

When I perform proc univariate in order to compute percentiles I obtain this output

	per20x1	per40x1	per20x2	per40x2
1	1165.91	1199.26	2.9595	2.995

I want to have this table

                    X1          X2

per20     1165.91     2.9595

per40     1199.26     2.995

[Ksharp]

try proc means + odsstack  option .

[Cynthia_sas · Accepted solution]

Hi:

  There is an example of how to get your percentiles into an output dataset in the documentation:

Example 4.8 Saving Percentiles in an Output Data Set

  However, AFTER you have the percentiles in an output dataset, to get what you want, you either need to restructure your dataset or move to a different procedure. This Tech Support note illustrates (with full code) how to reshape data from a Stat procedure.

25016 - Reshapes the default output data set from PROC UNIVARIATE, MEANS, or SUMMARY

cynthia