The SAS Output Delivery System and reporting techniques

Including a Legend for a Proc Tabulate in ODS TAGSETS.EXCELXP

Reply
Occasional Contributor
Posts: 14

Including a Legend for a Proc Tabulate in ODS TAGSETS.EXCELXP

I am able to output a proc tabulate to excel using ODS TAGSETS.EXCELXP. The output has multiple worksheets based on a variable. The table is comprised of colors to indicate a particular set of values.

For example, lets say I cross tabulated the number of deaths occurring at prisons by month in the USA. Each worksheet represents the state. Worksheet 1 is Alabama, worksheet 2 is Alaska, so on and so forth.   The cells are color coded to represent the number of deaths: low to 10 is green, 11-50 is yellow, 51-high is red.  If a 1-10 deaths occurs at a prison x1 in month 1 then it is green,  if 11-50 deaths occur in prison x1 and month 2 then it is a yellow cell.

I want to include a legend to show what the cell colors represent is on the worksheet, for each worksheet.

Is that possible?

Thanks,

Josh

Example of Table output.  I want to put a legend above the table to define the colors.

Month1Month 2Month 3Month 4Month 5
X1
X2
X3
Ask a Question
Discussion stats
  • 0 replies
  • 361 views
  • 0 likes
  • 1 in conversation