I was assigned to create a temporary data set 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!
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;"
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.