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!
@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.
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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.