I have a variable that represents responses to several surveys. There are over 200 unique responses, 60 of which are ordinal responses with a total n of 1,757 responses. For example, in one group of responses I have 'very difficult', difficult', easy' , and 'too easy' whereas, another group of responses may be ' yes', 'no', or 'not sure'. I need those responses sorted in that order. The vast majority of responses, however, are open-ended questions and they do not have to be sorted but I need them to appear in the same table as the sorted ordinal responses.
The "Custom Sort" feature in SAS Visual Analytics only allows a limited number of responses and will not even allow me to sort all of my ordinal responses. I created a user-defined format in SAS Enterprise Guide (sample of code shown below) and this allows me to sort the ordinal responses. However, I cannot display the ordinal responses and the open-ended questions in the same table on SAS Visual Analytics, and be able to sort the ordinal responses. Giving a unique value to each open-ended response would be too time consuming.
*sample of user-defined format; else if answerup = 'VERY UNLIKELY' then answer_code = 25; else if answerup = 'UNLIKELY' then answer_code = 26; else if answerup = 'POSSIBLY' then answer_code = 27; else if answerup = 'LIKELY' then answer_code = 28; else if answerup = 'VERY LIKELY' then answer_code =29;
else if answerup = '1 NOT CONFIDENT' then answer_code = 30; else if answerup = '2 SOMEWHAT UNCONFIDENT' then answer_code =31; else if answerup = '3 SOMEWHAT CONFIDENT' then answer_code = 32; else if answerup = '4 CONFIDENT' then answer_code = 33; else if answerup = '5 VERY CONFIDENT' then answer_code = 34;
data lib.survey; set lib.survey; format answer_code abe_answern.;
Notice how the responses in "Frequency of Use" and "One helpful thing learned" are alphabetical. I want the "Frequency of Use" to be sorted as 'Rarely' 'Sometimes' 'Often' 'Always' and "One helpful thing learned" to be sorted alphabetically.
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.