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.
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!
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?
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.