topic Re: Retrieving specific survey responses in SAS Programming

Retrieving specific survey responses

braak — Thu, 02 Aug 2018 15:01:02 GMT

I'm trying to clean up survey data that I have. There was a question on the survey that had a number of possible answers including "Other (please specify)". I'd like to be able to retrieve all of the responses for those who selected "other", and read what they wrote after "please specify". I just can't figure out what the command should be.

Appreciate the help!

Re: Retrieving specific survey responses

RW9 — Thu, 02 Aug 2018 15:09:35 GMT

There is no way we can possibly tell you. Please review the guidance found under the post button, on how to post a quesiton. Provide test data (in the form of a datastep), and what the output should look like. Also show what you have done to date, provide log excerpts with any error/warning messages etc.

Re: Retrieving specific survey responses

ballardw — Thu, 02 Aug 2018 15:50:12 GMT

@braak wrote:

I'm trying to clean up survey data that I have. There was a question on the survey that had a number of possible answers including "Other (please specify)". I'd like to be able to retrieve all of the responses for those who selected "other", and read what they wrote after "please specify". I just can't figure out what the command should be.

Appreciate the help!

Following is a skeleton program that you must modify:

proc print data=have;
   where questionresponse='Other (please specify)';
   var respondentid variablecontainingothertext;
run;

You have to change the data set name in place of have.

You must place the actual name of the variable that contains the "other specify" respons in place of questionresponse. the value in the quotes after the = must contain the value actually appearing in your data set. If it is a numeric code then no quotes, otherwise the text has to match exactly as it appears in your data set.

You must change the name of variablecontainingothertext with your SAS data set variable that contains the text.

I am assuming that you have some sort of respondent id variable, you include that as part of the output as it very often comes up handy for processing. (such as reducing the rambling text in the open end to an actual category that was provided as an answer).