How to Create a Raw Data Table From Variable(s)

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.

This article describes how to create a raw data table from variable(s).

Requirements

A Displayr document with a data set.

Method

Create a Page in your Report by hovering in the Report tree and clicking + > Page > select your page layout.
Select the variable(s) you wish to use to create a raw data table in the Data Sources tree.
From the toolbar, go to Table > Raw Data > Variable(s).
Click on your Page to place the output.
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, then press Calculate.
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 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.")
```
5. OPTIONAL: Check Data > Variable names to replace variable set names with their individual variable names.

6. OPTIONAL: To export this raw data to Excel, use Share > Export Report > Excel.