https://communities.sas.com/t5/SAS-Programming/Split-volume-of-records-into-10-equal-deciles-and-find-the-lower/m-p/542852#M150040 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SAS deciles.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/27902i5433910A62A0B725/image-size/large?v=v2&amp;px=999" role="button" title="SAS deciles.PNG" alt="SAS deciles.PNG" /></span></P> Wed, 13 Mar 2019 16:03:01 GMT jeremy4 2019-03-13T16:03:01Z https://communities.sas.com/t5/SAS-Programming/Split-volume-of-records-into-10-equal-deciles-and-find-the-lower/m-p/542852#M150040 <P>Hi,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SAS deciles.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/27902i5433910A62A0B725/image-size/large?v=v2&amp;px=999" role="button" title="SAS deciles.PNG" alt="SAS deciles.PNG" /></span></P> Wed, 13 Mar 2019 16:03:01 GMT https://communities.sas.com/t5/SAS-Programming/Split-volume-of-records-into-10-equal-deciles-and-find-the-lower/m-p/542852#M150040 jeremy4 2019-03-13T16:03:01Z https://communities.sas.com/t5/SAS-Programming/Split-volume-of-records-into-10-equal-deciles-and-find-the-lower/m-p/542858#M150045 <P>I have provided an answer in your original thread below</P> <P>&nbsp;</P> <P><A href="https://communities.sas.com/t5/SAS-Programming/SAS-code-to-find-upper-and-lower-bound-scores-that-would-create/m-p/542806/highlight/false#M150009" target="_blank">https://communities.sas.com/t5/SAS-Programming/SAS-code-to-find-upper-and-lower-bound-scores-that-would-create/m-p/542806/highlight/false#M150009</A></P> Wed, 13 Mar 2019 16:16:43 GMT https://communities.sas.com/t5/SAS-Programming/Split-volume-of-records-into-10-equal-deciles-and-find-the-lower/m-p/542858#M150045 PeterClemmensen 2019-03-13T16:16:43Z