topic Re: SAS Newbie: Is there a way to display one value in a cross tab without using the filter option? in SAS Visual Analytics

SAS Newbie: Is there a way to display one value in a cross tab without using the filter option?

abparks_jl — Fri, 16 Apr 2021 17:33:04 GMT

I am reporting on a customer satisfaction survey with SAS VA and this is all new to me. I normally use SPSS and have found SAS VA to be quite the learning curve.

Background:

I created a calculated item to summarize one of our questions. I used the IF/THEN statement where 1= Very satisfied 2= Satisfied etc. This part I am good and have displayed it on a cross tab (see attachment). My question is - i'd like to have a table that shows only the "Very Satisfied + Satisfied" total count and col %. When I try to do this using the filter option I noticed that it affects my total counts and column %. Is there a way to just hide the other values and keep "Very Satisfied + Satisfied" numbers only? I know there is a way to do this but am completely stuck on how to do that.

Any help from this community would be awesome. Thanks in advance!

Re: SAS Newbie: Is there a way to display one value in a cross tab without using the filter option?

Reeza — Fri, 16 Apr 2021 20:37:03 GMT

@abparks_jl wrote:

I normally use SPSS and have found SAS VA to be quite the learning curve.

Interesting....I wouldn't consisder VA to be a replacement for SPSS, Viya would be.

VA is more equivalent to Tableau/PowerBI and the thought of trying to analyze survey data in one of those makes my head hurt.

Re: SAS Newbie: Is there a way to display one value in a cross tab without using the filter option?

abparks_jl — Mon, 19 Apr 2021 14:47:25 GMT

Good to know! Perhaps I am fighting with the system to do something it wasn't designed to do. My assumption of what VA can do may be wrong so this is helpful to know.

Would you then suggest doing the analysis in SPSS or something equivalent and then use VA to display it in an interactive report?

Re: SAS Newbie: Is there a way to display one value in a cross tab without using the filter option?

Reeza — Mon, 19 Apr 2021 21:15:02 GMT

Do you have only VA or do you have Viya with the components to do data wrangling as well?
If not, I'd use something else and present results in VA.

Note that you can use VA to do this....just not sure you should be, especially if you need to do any data cleaning/recoding and such.

Re: SAS Newbie: Is there a way to display one value in a cross tab without using the filter option?

abparks_jl — Tue, 20 Apr 2021 14:27:09 GMT

Thank you for your response! You confirmed my suspicions that I was using SAS VA incorrectly or rather - trying to make it do something that it isn't so great at doing.

Really appreciate it. Saved me a lot of time fighting with the system.
Cheers