UPCOMING WEBINAR: Run Research Your Way With AI Skills A table of raw data can be used for various reasons, and is a common way of exporting raw data for a subset of cases or variables in your data set. More specifically this feature allows you to view and export:
- Raw data to Excel using category labels instead of values.
- Text responses next to categories created via Text Categorization.
- Specific variables to review cases for quality.
- A raw data table for an Appendix in your Report.
- Raw data using a filter or show only a subset of variables of raw data.
Requirements
A document with a data set.
Method
1. Create a Page in your Report tree by hovering and clicking + > Page and selecting the page layout.
2. Select the specific variables to export from your Data Sources tree that you want raw data for.
3. From the toolbar, click Table > Raw Data > Variable(s).
4. Click on the Page to place the output.
5. OPTIONAL: You can select more variables via the Properties > Data > Variables field.
6. OPTIONAL: Nominal variables that have merged categories and aggregated Date/Time variables will display as such by default. To change this to only show the original categories and/or responses, go to Properties > Data > Attributes > Code, and delete
ProcessQVariables from line 5 in the Code panel, then press Calculate.
7. OPTIONAL: If you have more than a million table cells, you will receive the following error message:
If you still wish to display your table, go to Properties > Data > Attributes > Code, delete the lines shown below (lines 8 and 9), and press Calculate:
if (nrow(rawdata) * ncol(rawdata) > 1000000)
stop("Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.")8. OPTIONAL: Tick Properties > Data > Variable names to replace variable set names with their individual variable names.
9. Go to Share > Export Report > Excel.
10. Select Export Selected from the Choose which pages/outputs to export dropdown.
11. Click Export.