I have the following example output table, where 1,2,3,4 are columns for:1) total sales 2012 2) % of total regions 3)Total sales for 2011 and 4) % for total region this is created by grouping different regions for the company. I would like to create a single cell trafficlight with Proc tabulate. that will affect the column 2012 percentage only for the North region as shown below. (I have the format done, I just need to know how to single specify North and the value of the single % representation). If possible, I would like to keep using pro Tabulate and not proc Report. North 16.220 37.5% 71.394 39.3% South 10.797 24.9% 37.095 20.4% East 5.938 13.7% 27.072 14.9% West 2.490 5.8% 11.846 6.5% NorthE 4.001 9.2% 18.016 9.9% SouthE 3.857 8.9% 16.357 9.0% Total 43.303 100.0% 181.780 100.0%
... View more