02-19-2015 04:09 PM
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?
Example of Table output. I want to put a legend above the table to define the colors.
|Month1||Month 2||Month 3||Month 4||Month 5|