office: +44 (0) 1491 825644
fax: +44 (0) 1491 832376
See Kat's Corner Tips for other tips.
Tip 10 - QPSMR Companion - Locate and Update Data Errors
In this tip I will explain how to quickly locate and update data errors using the
QPSMR Companion contains a comprehensive data checking facility that I recommend you use to check data you have collected, or data that has been provided by an external supplier.
If your questionnaire setup includes filters and input settings (such as range checks on integers and hold filters), QPSMR Companion will display all errors found.
For this tip I will use an example data file that I have altered so it contains a couple of errors!
|In my questionnaire, entry
AGEX is an integer with a minimum value setting of 18,
and I have also included a hold filter FHQ4AB to locate any
records where Q4A + Q4B does not total 100%.
Firstly, I will check the data file. From the Main window I select [Data] [Check data file…] then [Browse…] to find the data file then [Open], followed by [Check data] from the “Data check” dialog box. QPSMR Companion then checks the data and the errors found are displayed in a “Data log” dialog box.
|As you can see, the data file contains 2 errors, at serial 2 AGEX has a value of 15 (lower than the minimum setting of 18) and at serial 12 the hold filter is true (the Q4A + Q4B total does not equal 100). Assuming that these were paper records I would check the documents to determine the corrections, and the data can then be updated and saved, as follows:
[Close] the “Data log” dialog box and from the “Data check” dialog box (with the error types indicated) select [View data].
|At the Data view window, to make it easier to find the errors, select:|
|[View] [Rows to show] [Error rows only]|
|[View] [Columns to show] [Error columns only]|
|[View] [Columns to show] [Filters show]|
|[View] [Column widths] [Headers and contents visible]|
|The data can then be updated by double-clicking in the error cells, and amended by making selections from the QPSMR Companion Input screen, as follows:|
|For serial number 2, after double-clicking the error cell (AGEX), at the QPSMR Companion Input screen update 15 to be 18 then click [Close]|
|For serial number 12, after double-clicking the error cell (FHQ4AB), at the QPSMR Companion Input screen update entry Q4B, changing 60 to be 80, then click [Close]|
|When all changes have been made the red error markers will be removed from the “View” screen and I can use the [Save and unlock] button to save the file (selecting [File] [Save as] would allow me to save to a different data file).|
|Finally, I always recommend you to re-check your updated data to ensure you see the “No problems encountered” message.|
I hope you found these notes useful. Look out for more tips coming soon.
|Click for the Kat's Corner Tips page|