BookmarkSubscribeRSS Feed
wcp_fnfg
Obsidian | Level 7

Would like to cap my report at the top X observations.  Like if I had 10 students heights and only wanted to out the top 5 tallest.

Any thoughts?

2 REPLIES 2
SASKiwi
PROC Star

If you sorted your data by descending height then reported on the first 5 rows that would do it.

proc sort data = students;

  by descending height;

run;

proc report data = students (obs = 5);

........


wcp_fnfg
Obsidian | Level 7

Thanks for the reply.

That works, but I'm hoping to feed use a computed report variable to do my obs... I may have to add a few steps to do it, essentially, that way though.

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 2071 views
  • 0 likes
  • 2 in conversation