topic Re: Sum If in SAS Visual Analytics

Sum If

itchyeyeballs — Thu, 27 Oct 2016 14:39:17 GMT

Hi All,

Another newbie question I'm afraid!

I was trying to create a butterfly chart in VA, I manged to create the chart using graph builder but got stuck at defining measures. My data is very basic:

Staff_ID, Gender, Grade

I want one side of the chart to show male and the other female. How do I create a male and female measure? (Grade will be the category)

In MS Power BI I would just do calculate(counta(staff_id),gender="male") and that would create a measure that shows a sum off all males based on the context of the chart/table.

Many thanks

Phil

Re: Sum If

ShannonMoore — Tue, 01 Nov 2016 21:49:28 GMT

Phil, I am trying to visualize your data. So the grade will be the categorical value like an 'A', 'B', 'C', etc. or is a number that is treated as a category? Would you please give me a sample of couple of lines of the data? Also, when you say you used the Graph Builder, did you use the Butterfly example with no changes? Thank you, Shannon

Re: Sum If

itchyeyeballs — Wed, 02 Nov 2016 10:49:45 GMT

Hi,

Yes the grade will be categorical

A sample of the data could be

Staff_ID, Gender, Grade

1,M,G10

2,M,G8

3,F,G9

4,F,G1

Yes I did pick the butterfly example with no changes.

Thanks