BookmarkSubscribeRSS Feed
BStats
Calcite | Level 5

Hello All,

 

I have some questions, regarding percentiles in proc univariate. I am able to calculate the percentiles from 50 to 100 by 5 using the below output statement. 

 

output  pctlpre=P_ pctlpts=50 to 100 by 5 ;

 

When doing so I get the 80-100th percentile equal a success rate of 100. Does this mean that any one with a success rate of 100 belongs in all of these percentiles? Also, is there a way that I can have sas create a data set for me with a column indicateing what percentile everyone belongs in? 

 

ID SR Pct
1 100 100
2 82 50
3 97 70

 

How would that work with 80-100 being equal?

 

Thanks for your help.

 

 

3 REPLIES 3
ballardw
Super User

It probably reflects either the number of responses or the number of unique responses in your data.

If you only have 5 response for instance, 1,2,3,4,5 then the Value 5 would have percentiles from 85 to 100.

 

You may need to clarify exactly what you mean for percentile if you have fewer than 100 responses to work with as in that case you will have multiple integer percentiles (1, 2, 3,  ...,98,99) possible for the same value.

 

One way would be to use PROC Rank with groups = 100 for your numeric variable

 

proc rank data=have out=want groups=100;

    var variablename;

    ranks variablenamerank;

run;

BStats
Calcite | Level 5

I have over 250 observation with 20 unique success rates. 

Reeza
Super User

If you have 20 unique values then each one will represent a percentile group of 5% roughly. 

 

This depends a bit on how you define your percentiles. Look at the PCTLDEF option in Proc Univariate to see your options

 

http://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#procstat_univaria...

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1514 views
  • 2 likes
  • 3 in conversation