The SAS Output Delivery System and reporting techniques

Saving Percentiles in an Output Data Set

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 118
Accepted Solution

Saving Percentiles in an Output Data Set

hello,

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

per20x1per40x1per20x2per40x2
11165.911199.262.95952.995

I want to have this table

                    X1          X2

per20     1165.91     2.9595

per40     1199.26     2.995


Accepted Solutions
Solution
‎11-08-2014 10:21 AM
SAS Super FREQ
Posts: 8,868

Re: Saving Percentiles in an Output Data Set

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

View solution in original post


All Replies
Super User
Posts: 10,041

Re: Saving Percentiles in an Output Data Set

try proc means + odsstack  option .

Solution
‎11-08-2014 10:21 AM
SAS Super FREQ
Posts: 8,868

Re: Saving Percentiles in an Output Data Set

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 477 views
  • 0 likes
  • 3 in conversation