BookmarkSubscribeRSS Feed
233
Calcite | Level 5 233
Calcite | Level 5

Hi,

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!

1 REPLY 1
pau13rown
Lapis Lazuli | Level 10

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;"

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1277 views
  • 2 likes
  • 2 in conversation