Hi all, So, I'm trying to use the coding for the Top_N Report located at this link: http://support.sas.com/kb/33/009.html These are the tips stated in the comments at the beginning of the program: /*************************************************/
/* TOPNCATEGORIES.SAS */
/* Top N report for data across categories */
/* Use macro variables to customize the data */
/* source. */
/* DATA - SAS library.member for input data */
/* REPORT - column to report on */
/* MEASURE - column to measure for the report */
/* MEASUREFORMAT - specify to preserve measure */
/* format in the report (currency, for example) */
/* STAT - SUM or MEAN */
/* N - The "N" in Top N - how many to show */
/* CATEGORY - across which category? *
/*************************************************/ In the example on the SAS Support page, report = Model (of car) measure = MPG_City category = Origin Producing a Top_N Report of Top Models by MPG_City for each region of Origin. In my data, I have three variables Location Happiness Confidence Which of these are the measure, category and report variables? I am assuming that category = location but what about my other two variables? My variables are independent variables. What I would like is a table ranking the Top 10 scores of Happiness and Confidence by Location.
... View more