Create a Top N report in SAS

The SAS support site has a new example of how to create a Top N report using SAS.

The Top N report is pervasive in our society. From the Billboard Top 100 to the New York Times Best Sellers list to the Forbes list of the 100 Richest Americans, the Top N list is a medium that we can all understand: which are the top “whatevers” that stand out from the rest?

Businesses rely on reports like these every day. It begins with what seems like a simple question. For example:

  • "Who are our top ten customers, measured by amount of sales?"
  • "Who are the ten most effective sales associates in each region?"
  • "Which are the five top-selling brands for each product family that we distribute?"

The example includes 4 different SAS programs that do the job.

If you don't like to program, then you can use the custom task (click for picture) for SAS Enterprise Guide instead, and get it done with point-and-click. (See the Downloads tab in the sample get to the custom task.)

As with all SAS samples, your feedback is welcome and encouraged. Did the sample help you? Is it clear how to use it? Did you (gosh forbid) find a problem with it? Let us know.

tags: PROC REPORT, SAS custom tasks, SAS tips, top n report

2 Trackbacks

  1. [...] available for you to download and install? These tasks provide all sorts of capabilities, including new analysis and reports, productivity tools for programmers and utilities that help you to manage your projects. Many of [...]

  2. [...] Top N Report [...]

Post a Comment

Your email is never published nor shared. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>