How to Export Specific Raw Data Variables to Excel

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.

Next

How to Export Data Sets to SPSS or CSV Format from Displayr