How to calculate a percent of total of quarter?

MClay — Fri, 17 Apr 2020 14:47:39 GMT

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!

Re: How to calculate a percent of total of quarter?

KeithM — Fri, 17 Apr 2020 17:59:38 GMT

Try creating an aggregated measure that looks like the following:

sum(_bygroup_(Var0))/sum(_ForAll_(Var0))

Re: How to calculate a percent of total of quarter?

MClay — Tue, 21 Apr 2020 12:07:58 GMT

That worked perfectly, thank you!

topic Re: How to calculate a percent of total of quarter? in SAS Visual Analytics

How to calculate a percent of total of quarter?

Re: How to calculate a percent of total of quarter?

Re: How to calculate a percent of total of quarter?