Hi! I'm a novice SAS user and looking for help with a dataset. It is survey data where each row corresponds to a respondents' answer to one of 35 questions. There are close to 9,000 respondents and questions could be skipped so this is quite a mess. I'd like to transform the dataset into something useable for analysis such as one row for each respondent and one column for each question variable. I'm not sure how to do that in SAS Studio. I've read about merging, but that seems to apply more to merging two datasets, not one jumbled up mess of a dataset. Below are examples of the current dataset format and what I'm trying to transform it into. Any suggestions or guidance would be greatly appreciated. Thank you so much! Jen Example of current dataset: Respondent ID Question Answer A 1 Yes B 1 No C 1 No E 1 Yes A 2 No B 2 Yes D 2 Yes B 3 Yes D 3 No E 3 No Example of what I'd like to create: Respondent ID Question 1 Question 2 Question 3 A Yes No missing B No Yes Yes C No missing missing D missing Yes No E Yes missing No
... View more