topic VA - Show all results in one row in SAS Visual Analytics

VA - Show all results in one row

html82 — Thu, 30 Jun 2016 06:17:14 GMT

I'm new to SAS VA, and wanted to know in SAS VA, which object that can allow me to create chart like below ?

I tried bar char option, but only can get a result like below.

Re: VA - Show all results in one row

WKruk — Thu, 30 Jun 2016 21:11:42 GMT

Try to use a cross tab object with your category in columns and a proper measure (frequency or other you want to use).
Next, use Rules from a right pane and define condition when the background is green or yellow.

Re: VA - Show all results in one row

html82 — Fri, 01 Jul 2016 06:39:23 GMT

Thanks for your replied.

Next question is how to remove Frequency label ?

Re: VA - Show all results in one row

DJongman — Fri, 01 Jul 2016 09:18:37 GMT

Depending on the data, also possible in a List Table.

In test I created 3 new Aggregated Measures

These measures are giving only one value back.

Add a List Table to the project and added the aggregated measures

Created display rules on the List Table:

Screenshot of the rule settings:

And the List Table: