%let rankme =crscore;
proc rank data=indsn(keep=&rankme.) fraction ties=mean out=outdsn.;
ranks &rankme._ranked ;
proc means data=outdsn. n nmiss min mean median max range std;
|Variable||N||N Miss||Minimum||Mean||Median||Maximum||Range||Std Dev|
The Fraction option is in parallel to the Group option that is used most often and longest. The Fraction option allows for probability based grouping, normalizes the distribution and caps it between 0 and 1. One variation of the Fraction option is NPLUS1 that yields similar results.
In this case, the original 39,779 observations are collapsed to 257 groups. The following is a portion of the group distribution
Computation wise, the Fraction and NPLUS1 options are among those Proc Rank options supported through SAS in-DB technology. As of today February 2nd, 2013, the supported databases include Oracle, Teradata, Netezza and DB2. The probablistic grouping can be executed inside supported database tables without having to query and move big data to SAS environment.