Split volume of records into 10 equal deciles and find the lower and upper limit of each band

[jeremy4]

Hi,

I have a dataset with a volume of 93,260 records and would like to split it into 10 equal bands (volume wise) based on the variable 'application_score'. Is there a way of identifying the lower and upper limits for each of the band in the Results/Output data tab, similar to an example I have created below? If there were 100 records in total in my dataset, the code would split it into 10 groups of 10 records and identify the band's lower and upper bounds for each band (e.g. 500 as the lower bound and 575 as the upper bound for band 1). Thanks.

[PeterClemmensen · Accepted solution]

I have provided an answer in your original thread below

https://communities.sas.com/t5/SAS-Programming/SAS-code-to-find-upper-and-lower-bound-scores-that-wo...