Bar graph with SHOWING zero frequencY

[hiteshbhatt]

Hi,

I am creating simple bar graph for some categories (Officers & Completed tasks) using SAS VIYA 8.3.1. When the officer has "Zero" completed tasks then entire category of "completed tasks" disappears from the graph.

I want to pop-up all categories on graph even they have "Zero" values. Please show me how to enable showing "Zero" Frequencies on the bar graph?

[Reeza]

Is that value in your data as well?

[hiteshbhatt]

No not in data, it's the frequency calculated only like;

------------------------------------------------

Task   Officer              status

------------------------------------------------

1         Officer1         completed          

2         Officer2         memo    

3          Officer1        Started

4         Officer1         transferred

5         Officer2         completed

6         Officer2         completed

7          Officer3        started

---------------------------------------------------

I am doing graph of Status, controlled (Drop-down) by Officer   when I pick Officer3 it should display zero completed..

Thanks

Hitesh 

[Reeza]

I think you'll need to build an intermediate table for this then, that has the summary statistics you want to present where you deal with the missing levels at that stage and then feed that into the graph. If the data doesn't exist, SAS can't know to display it.

[hiteshbhatt]

Does this intermediate table updates automatically if original table is updated/replaced?

[Reeza]

Depends on where you add it, but if it's part of the design plan it should.