Bar Chart categories with no data

[Ingrid88]

In VA, my bar chart only displays categories that have data. Is there a way to show all categories, even if they do not have any data?

[PeterWijers]

Hi Ingrid,

I can not find a way to do this in SAS VA itself.

Please consider creating zero records for all occurrences in your database.

Several times I had to solve this issue just by adding 0 value records for all selectable instances that had no value.

greetings and good luck,  Peter

[MichelleHomes]

If you're creating a chart over time then you may want to consider using a Time Series Bar Chart and the tips that @TriciaAanderud suggests at http://bi-notes.com/2015/12/sas-va-insert-your-own-months/

Alternatively you can create a "helper table" as in the blog post to create 0 records which @PeterWijers suggested.

Cheers,

Michelle