I'm trying to find a procedure in SAS that produces percentiles according to the formula 100*(n-1)/N-1 where n is the rank score and N is the total number of observations.
For example, suppose I have three values: 10, 40, and 50. MS Excel calculates the percentiles as 0%, 50%, and 100%. Using the PROC RANK procedure, I get percentiles of 33%, 66% and 100% using the PERCENT option or 25%, 50%, and 75% using the NPLUS1 or GROUPS=100 option.
Am I missing something? Do I have to code this in a DATA step to get what I'm looking for?
I'm not sure I understand the utility of this solution. The output assigns the value 10 to all percentiles between 0% and 33%. I would expect the 10 value to be assigned just to 0%. Using the formula in my first post, the percentile would be 0% and not any other values. The second value, 40, would be assigned a percentile of 50%, not all the percentiles between 34% and 66%.