We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!
Why Extracting Data containing NULL values denoted by 'UNK' is being extracted as 'N'
Greetings from New Zealand - I am extracting the data from OpenClinica using a dataset I created – I found that where the data value was ‘Unknown’ – it was being extracted as ‘N’ and not ‘UNK’. During setup of the Study Event definition – ‘UNK’ was selected to represent NULL values. (highlighted RED below)
Setup of Study Event Definition for Baseline CRF
Here is example of where ‘Unknown’ was selected for a data field viz. Previous Vascular disease (highlighted RED below) for subject 1001
Baseline Data Entry for Subject 1001
However when we extracted the data for the Baseline CRF – the store value for data field ‘Previous Vascular Disease’ for patient 1001 is ‘N’ – not ‘UNK’
Any ideas why ‘N’ is being extracted and no ‘UNK’ see excerpt of data extract
Excel Spreadsheet of Baseline Data Extract
Any ideas on why this maybe happening and how to resolve it will be much appreciated .
Thanking you in advance.
"...If its not documented, it didn't happen... if its not signed, nobody did it..."