topic Re: SAS VA (VIYA) CROSS TABLUATION in SAS Visual Analytics

SAS VA (VIYA) CROSS TABLUATION

vallsas — Wed, 27 Apr 2022 14:29:54 GMT

Hi All,

I am trying to create a crosstab report in va as Row variable, column variable with Measure value as i want to see the matrix of the row x column measure value as

it shows the sparse values (--) .

also I would like to hide the measure value column names under the actual column name. please share if you come across this kind of issue.

thanks in advance!

Re: SAS VA (VIYA) CROSS TABLUATION

Madelyn_SAS — Thu, 28 Apr 2022 15:44:31 GMT

I am not able to visualize what you are asking. Do you have an example that you can post?

Re: SAS VA (VIYA) CROSS TABLUATION

vallsas — Tue, 10 May 2022 06:29:01 GMT

Hi Madelyan,

I am creating the cross tab report in va (viya) as i have selected column,row and measure. The combination of matrix some cross column * row does not have value so it appears as (---) .

also i have another question on the same cross tab as I have column,row and measure and I dont want to display measure name on my cross tab and would like to show only value

column a b c d

(measure) yye ure ree gea

row

aa 10 5 2 ---

bb 20 5 6 55

cc 58 120 55 78

dd 47 45 87 ---

as shown in above table (measure) i have added for your understaing as I dont want to disply yye ,ure,ree gea

please let me know thanks in advance

Re: SAS VA (VIYA) CROSS TABLUATION

Madelyn_SAS — Tue, 10 May 2022 15:34:57 GMT

On the Options tab, you could change the color of the measure heading to white, or whatever color the background of the table is.

Re: SAS VA (VIYA) CROSS TABLUATION

vallsas — Fri, 13 May 2022 10:33:06 GMT

Thank you , this help us by suppress the name of the measure.

any about the -- in the above report .

Re: SAS VA (VIYA) CROSS TABLUATION

Madelyn_SAS — Fri, 13 May 2022 14:39:41 GMT

Using horizontal lines to represent non-existent values (aka, sparse values) is expected for a crosstab in 8.5 and later. That behavior cannot be changed. I don't see in the thread where the version is mentioned. Are you using 8.5 or later?

Re: SAS VA (VIYA) CROSS TABLUATION

vallsas — Fri, 13 May 2022 18:35:00 GMT

yes, we have sas viya 3.5 visual analytics will it helps anything.?

Re: SAS VA (VIYA) CROSS TABLUATION

Madelyn_SAS — Fri, 13 May 2022 20:42:14 GMT

It does confirm that the lines indicating sparse values are expected. Unfortunately, you cannot remove those unless you change the data to be something other than sparse (e.g., missing or some dummy value).

Re: SAS VA (VIYA) CROSS TABLUATION

vallsas — Sat, 14 May 2022 03:57:12 GMT

okay thank you very much for the information.