01-21-2014 10:37 AM
A very useful way to compare distributions that vary in size is stacked bar charts that add up to 100%. For example, excel has a 100% stacked column chart, which automatically converts to percentages and displays cells as a percent of the row or column total -- see attached example. So far I haven't found the magic combination to do this in SAS -- adding percents to a crosstab just converts each cell to a percent of the overall total, not a percent of the row or column total...help!
01-21-2014 06:48 PM
If it is of interest though you could using VA Designer to show the percentage of each category using a stacked bar chart as below. The data you provided needs to be rearranged to achieve this as follows:
01-22-2014 03:08 PM
Very helpful -- thanks! Where did the "amount" measure come from -- did you calculate it, and if so, how? Granted I've been doing all my data prep in enterprise guide and have only worked with the reporting end of VA, but I don't see "amount" as a measure there...
01-22-2014 03:44 PM
Glad to see it is helpful.
I rearranged the table you had in your excel spreadsheet and created an amount column for the figures (see screenshot above). So amount is whatever your measurement column is. Compare my screenshot to what you provided in your attachment in your first post.