...
After your missing data codes have been set up, you will see an 'M' icon next to each field when viewing a data entry form. Click the icon to open your list of missing data codes, and select one.
Once selected, it will save the missing code as the literal data value for the field.
You can see the missing code on the form:
You can also see the missing code on data exports:
The checkbox field [family] was exported, and you can see the 3 standard responses are blank for this participant (highlighted in blue), then the missing data codes for this field are highlighted in yellow, with '1' listed for “OTH” which was selected as the missing data code.
If no missing data codes were selected for any participants for a field, only the standard responses will export for that field.
Missing data codes can be manually entered as described above, or imported which is the recommended practice for large sets of codes needing to be assigned to many participants across multiple fields.
Prepare an excel file with A1: record_id
A2-# should have the participant ID numbers
Columns B-# should have the field name(s) that you’d like to import Missing Data Codes as the 1st row
all fields, except checkbox fields, should have their variable name typed as-is
missing data codes should be typed in the rows beneath the variable name
checkbox fields should have their variable name typed, followed by 3 underscores and the missing data code. (e.g. if the checkbox field’s variable name is family, and I want to import values for missing data code NA then I would type family___na)
the value 1 should be typed beneath the variable-missing data code name
An example is provided below that needs some missing data codes imported for a few records, with [email] as a text field , [family] as a checkbox field, and [utahn] as a radio field.
Please note, if you are using a longitudinal design you’ll need redcap_event_name as column B. If you are using repeating instruments you’ll need redcap_repeat_instrument and redcap_repeat_instance as columns B and C.
Save the excel file as a .csv
Navigate to the data import on your REDCap left menu
Import the .csv file
...