Prev: replicate PROC AUTOREG using PROC REG
Next: How to create 10 deciles using Proc Rank when there are too
From: newtous on 30 Jan 2010 14:26
Hello everyone,
I am trying to create 10 deciles using Proc Rank out of a dataset with
about 100K obs. Here is the code I used:

Proc rank data=mydata out=r_mydata group=10 ties=low descending;
var myscore;
ranks r_myscore;
run;

Unfortunately I got fewer than 10 deciles - for some score I got
decile 0-7, some decile 0-5. The reason is that there are too many
ties (e.g. ties with value of 0.000) in the data. The last decile has
more than 10K obs because SAS treats all the zeros as the same, so
decile 7 has 30K instead of the desired 10K.

Can anyone help with this? I am trying to decide the decile cut
values. Or does it even make sense to include all the ties?

Thanks in advance for any help.

Nick Yang
 | 
Pages: 1
Prev: replicate PROC AUTOREG using PROC REG
Next: How to create 10 deciles using Proc Rank when there are too