Hi all,
I have a survey where respondents are sent through a loop and merge for 2 out of 10 possible options. However, when I've tried to analyze data this 1) creates hundreds of duplicative columns in excel, and 2) doesn't show which option was looped through in statsiq, crosstab, and other options (and the questions are duplicated again).
I'm wondering if there are any ways to make this data quick and reliable to analyze? Such as flattening the duplicate questions, identifying which option each respondent actually answered for, creating an unpivoted view (a row per question), or any other suggestions? It seems like an easy survey will require many hours to transform the data into a state where it can actually be analyzed, there has to be a better way.
Question
Best Practices for Efficiently Analyzing Loop and Merge data?
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.