topic Re: Display "X" at cross section in crosstab report in SAS Visual Analytics

Display "X" at cross section in crosstab report

pradeepalankar — Fri, 27 Feb 2015 10:26:58 GMT

Hi,

I want to display "X" in the cell at the crosssection of crosstab report, by default it is showing frequency number as 1. instead of this frequency i want to display "X" at crosssection.

current situation:

X/Y	a	b	c
aa	1
bb		1
cc			1
dd

desired output:

X/Y	a	b	c
aa	X
bb		X
cc			X
dd

Re: Display "X" at cross section in crosstab report

MichelleHomes — Fri, 27 Feb 2015 10:47:45 GMT

The output you are seeing is the expected behavior of a crosstab report object. Without a measure data item in a crosstab, the cells represent the frequency of the X/Y combination. If you are wanting to see an X instead, I would suggest implementing a workaround by having a measure in the crosstab and define a SAS user-defined format on the measure such that values greater than 0 are a 'X' and values less than or equal to 0 are ' ' (a blank).

You can create a SAS user-defined format using PROC FORMAT as described at Base SAS(R) 9.4 Procedures Guide, Third Edition - PROC FORMAT and information on how to set up your VA environment to use SAS user-defined formats can be found at SAS(R) Visual Analytics 7.1: User's Guide - Work with User-Defined Formats

Let us know how you go.

Kind Regards,

Michelle

Re: Display "X" at cross section in crosstab report

TejaSurapaneni — Fri, 27 Feb 2015 11:16:31 GMT

Hi Pradeep,

Instead of measure values you cant show X....., you can show any numeric value like 0, 2, 3....., In VA Environment.

Thanks,

Teja surapaneni.

Re: Display "X" at cross section in crosstab report

PeterWijers — Tue, 03 Mar 2015 05:42:06 GMT

Hi there,

please consider while working in "Visual" analytics to use some colors.

If you assign colors for the "X" and non "X", that really catches the eye.

You can still choose to hide the value's assinging the same color.

Greetings and succes.

Peter

Re: Display "X" at cross section in crosstab report

MichelleHomes — Tue, 03 Mar 2015 07:04:17 GMT

Good point Peter!