I want to download my survey data into a CSV file for Excel. When I download it I get the text answers to my survey questions, but I’d like the download to include the “reporting values” so that I can analyze the data in Stata. I read your article about how to display answers as “reporting values” but this seems to only apply to reports, not to exports. After I changed “answer option names” to “reporting values” as this article suggests (https://help.surveygizmo.com/help/reporting-values#reporting-values-in-reports-and-exports) I re-exported my data and the file is blank. Can you help me figure out how to export the data with reporting values in a CSV file (it won’t help me to export into SPSS as I do not have that program)?
I had the same problem. This is what I did (in SPSS): created a syntax for each field (where the problem exists) e.g.:
I also made a syntax to change the variable names, e.g.:
(sg_extended_variable_name = variable_name).
Can you create syntaxes in STATA?
The CSV Raw Data Export includes reporting values by default (there is actually not a way to export anything but the reporting values – if you have not customized reporting values, the export will default to exporting the answer options):
If you have been updating reporting values, it may take a little time for everything to propagate through servers. I would also recommend creating a brand new export if you haven’t tried that already.
I hope this helps!