https://communities.sas.com/t5/SAS-Procedures/which-statement-should-I-use-to-display-the-top-15-players-with/m-p/476661#M71239 <P>you would want to sort the dataset in descending order first "proc sort; by descending efficiency; run;" and then there would be a number of ways to select the first 15 obs of this dataset, eg just count obs and "proc print data=xxx (where=(count le 15)); var efficiency; run;"</P> Tue, 10 Jul 2018 04:43:07 GMT pau13rown 2018-07-10T04:43:07Z https://communities.sas.com/t5/SAS-Procedures/which-statement-should-I-use-to-display-the-top-15-players-with/m-p/476657#M71238 <P>Hi,</P><P>I was assigned to create a temporary data set&nbsp;that contains the top 15 players with the highest efficiency rating. Efficiency rating is one of the variables in the dataset. I was wondering which statement could I use to solve this kind of problem? (I only learned about where, if, proc freq statements like that) Thanks!</P> Tue, 10 Jul 2018 03:50:18 GMT https://communities.sas.com/t5/SAS-Procedures/which-statement-should-I-use-to-display-the-top-15-players-with/m-p/476657#M71238 233 2018-07-10T03:50:18Z https://communities.sas.com/t5/SAS-Procedures/which-statement-should-I-use-to-display-the-top-15-players-with/m-p/476661#M71239 <P>you would want to sort the dataset in descending order first "proc sort; by descending efficiency; run;" and then there would be a number of ways to select the first 15 obs of this dataset, eg just count obs and "proc print data=xxx (where=(count le 15)); var efficiency; run;"</P> Tue, 10 Jul 2018 04:43:07 GMT https://communities.sas.com/t5/SAS-Procedures/which-statement-should-I-use-to-display-the-top-15-players-with/m-p/476661#M71239 pau13rown 2018-07-10T04:43:07Z