topic Re: Bar chart for binary data in SAS Visual Analytics

Bar chart for binary data

smm662002 — Mon, 13 Dec 2021 11:02:16 GMT

Hello,

SAS VIYA: 3.5

SAS Visual Analytics: 8.5

Having a table with the following structure (table is loaded in CAS) would it be possible to create a bar chart like in the example below without having to create new a new table (in SAS Studio) to summarise the data? I'm wondering if it is possible to manipulate the data only in SAS Visual Analytics.

V1	V2	V3
0	0	0
1	0	0
1	0	0
1	1	1
1	1	1
0	1	0
1	1	0
1	1	1
	1	0
	1	0
	1

Thank you,

smm662002

Re: Bar chart for binary data

LinusH — Mon, 13 Dec 2021 11:49:51 GMT

Hi,

I'm not good enough in VA to tell if this would work or not, but the data presented is not in optimal layout for reporting generally speaking.

Any classifier should be a value in a classifer column, not a variable/column itself.

So I would create a "Vn" column, with values 1, 2 and 3 respectively.

This will give you more flexibility when creating reports, and also being more tolerant for New V's (V4 etc).

Re: Bar chart for binary data

smm662002 — Mon, 13 Dec 2021 12:11:44 GMT

Hi,

Thank you for your answer. The data presented in the post is just an extract from a larger table having over 100 columns and a few million records. This data is calculated data rather than raw data. The data can have further transformations, but the question was if the desired chart can be created in SAS Visual Analytics using the data as it is now.

Thank you,

smm662002

Re: Bar chart for binary data

acordes — Mon, 13 Dec 2021 14:14:45 GMT

It's not a lucky design choice to have the category or group items as variables, in this case v1, v2, v3.

Your table should be transposed as it is in wide format but you need a long format.

data test1;
array x  v1 v2 v3;
do i=1 to 50;
do over x;
x=rand("bernoulli", 0.8 + min(0.2, max(-0.8, rand("normal", 0,1))));
end;
output;
end;

run;

proc transpose data= test1 out=test2;
var v:;
by i;
run;

data public.test2(promote=yes);
set test2;
run;

Re: Bar chart for binary data

LinusH — Thu, 13 Jan 2022 14:53:32 GMT

Now I had some time to play around.

And I can't see that this can be done OOTB.

Since your data is already calclated you might be able to adjust that, so it suits general reporting/analysis needs.

As stated intially, and by @acordes, make life easier by transposing your data.