topic Re: Missing categories in bar chart in SAS Visual Analytics

Missing categories in bar chart

Caro2 — Thu, 11 May 2017 10:14:41 GMT

Hi all,

It's my first time in the forum so I hope this question hasn't been posted before.

My problem with SAS VA is that when using a bar chart, some of my groups don't have values in every category. Thus in these categories, there is no bar shown. is there a way to show a "zero" bar or at least a missing space where that bar should normally be? here is an example:

Re: Missing categories in bar chart

RW9 — Thu, 11 May 2017 10:24:04 GMT

Well, first thing that comes to my mind, just add a row in your data for each missing category, with a result of 0, then all the categories will appear.

Re: Missing categories in bar chart

Caro2 — Thu, 11 May 2017 10:26:19 GMT

yes that would be possible, but I would need to think about every possible combination of categories and also filters that may appear which makes this really hard. I was hoping for an easier solution directly in VA...

Re: Missing categories in bar chart

RW9 — Thu, 11 May 2017 10:34:11 GMT

Well, I can't help with VA specifics, however code wise its pretty straight forward, just create a template of your categories, and then merge that with the data you have. If you need specifics per parts of your data then proc sort distinct your data for the values you want, add a do loop to assign the categories, then merge back.

Re: Missing categories in bar chart

itchyeyeballs — Thu, 11 May 2017 11:34:15 GMT

You may be able to use a calculated query with the missing function to force VA to output a value.

Something like

Re: Missing categories in bar chart

jm1309 — Thu, 05 Jul 2018 14:41:38 GMT

I have tried this, but the bar and label is still missing from the bar graph. Not sure if this is because it's a zero value or if report designer doesn't recognize the value resulting from Boolean transformations (I get the concept but don't know the proper terms!). Has anyone managed to force the graph to display the label?

Re: Missing categories in bar chart

itchyeyeballs — Thu, 05 Jul 2018 14:52:14 GMT

what happens if you try 0.000001 instead of 0 (just as a test)

Re: Missing categories in bar chart

jm1309 — Thu, 05 Jul 2018 15:16:28 GMT

Thanks for the suggestion. I had tried this with 0.1 and it still didn't work. Will keep experimenting.

Re: Missing categories in bar chart

xiluzhang — Fri, 15 Feb 2019 14:30:23 GMT

Hello,

Any solution within VA for this yet? I am running into the same issue with a crosstab.

Thank you!

Re: Missing categories in bar chart

Madelyn_SAS — Tue, 19 Feb 2019 18:42:43 GMT

Visual Analytics cannot show a row that does not exist in the data source. In this example, there is no Status for TaskA for Jan 12 and Feb 12 but those rows do exist in the data source with missing values. If rows 4 and 5 did not exist at all, Visual Analytics could not insert them.

This is what the table looks like with missing values in rows 4 and 5. If rows 4 and 5 did not exist, then TaskA would show only one row: Success.