Viewing data

<< Click to Display Table of Contents >>

Navigation:  User Guide > Data > Handling data >

Viewing data

Companion

From the Main window you can:

[Data] [Update data file]

[Data] [View data file]

You will be asked for a data file from the Data read user control and then both these options place you at the Data view window.  The menu option "Updating allowed" is set appropriately.  You can change this later if you wish.

For fixed format data which has verbatim questions you will be asked if you want to read the Verbatim file associated with your chosen data file.

The Data view window is used to inspect and change the information in a raw data file.

The checks are the same as those described in Checking data.  The [Checks] menu can be used to turn on or off the checks listed in phases 2 and 3.  The data can also be cleaned before viewing, as described in phase 3.

If any errors are found then a Data error log is displayed with a list of the errors.

This window can also be reached from Data Check to view the data already checked.

Data display

The data is listed in a data grid view, with a row for each serial and the entries as the columns.

Any questions that had an error during checking are marked. Any rows with one or more errors are also marked.

The answers are shown for each question.  If they are empty (blank), then a special null display is used.

For single-coded questions and variables the response number is shown.

For multi-coded questions and variables the response numbers, separated by a space, are shown.

Filters are shown as check boxes that are checked if the filter is true.

You can restrict the row display to only those with errors.

You can restrict the column display to only those entries selected in the Main window. You can also choose whether to show filters and variables in the display as well as the questions.

Each row contains a serial number column and the serial number is also used on the row header.  The row headers can be changed to show another entry if required.

If you are displaying selected entries, then you can change the entries selected on the Main window and refresh the display to only show the newly selected entries.

Data changes

TIP: Double clicking a cell will take you into the Input module starting at that question.

The answer to any question can be changed in the Data view window.

The altered answer is not used until you move away from the cell being changed.  When this happens the new answer is checked.  If the new answer is not valid for the question type then the old value will be restored.

If the new answer is acceptable then the whole row is checked and the filters and variables are recalculated.  Any error marking is redone for this row only.

The checks that are done when changes are made can be selected from the [Checks] menu. See Data Check for details. There is also a facility to recheck the whole file using the chosen checks.

You can choose to clean (force edit) the data by removing faulty answers as they are checked.

Records can be deleted and new ones added.

IMPORTANT: once a data file has been changed it is locked to other users until it is saved.

IMPORTANT: the data file is not altered until it is saved. Until then only the view has been changed.

Saving data

The data saved will be as it is shown in the display, as it has been cleaned and edited.

The data file can be saved (and a copy saved in the Archive sub-folder) or it can be saved to a new data file as:

CSV file

Raw data file (and verbatim file if appropriate)