I imported a dataset from the Pew Research Center https://www.journalism.org/dataset/spring-2018-survey-on-factual-and-opinion-statements-in-the-news/. It's an SPSS format which I've never worked with before. I imported the dataset into R Studio as "Import from SPSS" file (I know previous people who have posted here imported to CSV). The data was taken from a survey. And I can't see every column that I know was a survey question asked. I know previous forum posts said R Studio can only handle 100 columns, but mine currently has 158. Some of the questions were "check all that apply" and they've been separated into multiple columns for the one question. Do you recommend:
- Combine the "check all that apply" columns into one column for each question? Is that possible?
- I delete columns I don't want or need?
- OR is there a way to import the dataset to come in with all columns at once?
If I do any of the above or something else, will it start to show the columns? I’ve tried re-importing it, and the attached screenshot is what the end of the dataset looks like. Do you have any ideas? Thank you so much in advance!!