Hello! I am using SAS VA 7.5. I would like to calculate percent of total for quarter and display results in a bar graph to see change over time. Below is an example of how my data are structured and an example of the desired graph. The category=year and lattice columns=quarter.
Q | Var1 |
Q1 | 0 |
Q1 | 1 |
Q1 | 0 |
Q1 | 0 |
Q2 | 0 |
Q2 | 1 |
Q2 | 1 |
Q2 | 0 |
Q3 | 0 |
Q3 | 1 |
Q3 | 1 |
Q3 | 1 |
So I would like to visualize Var1 going from 25% to 50% to 75% over Qs 1-3. I experimented with right-clicking the variable, creating new calculation, and percent of total but this, of course, used all data and didn't segment by quarter. I have also tried creating a new calculated variable from the data pane and creating an aggregated measure but it was incorrect.
I'm also curious what dates VA uses for it's preset quarters in aggregations. I need to use non-standard dates (e.g. Q1=Oct-Dec) which should factor into the calculation.
Any suggestions are appreciated, thank you!
Try creating an aggregated measure that looks like the following:
sum(_bygroup_(Var0))/sum(_ForAll_(Var0))
Try creating an aggregated measure that looks like the following:
sum(_bygroup_(Var0))/sum(_ForAll_(Var0))
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.