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!
Missing data in items when downloading a dataset
We are using OpenClinica 3.13 (Version: 3.13 - Changeset: 74f4df3481b6 2017-02-28 15:27 +0000), and we are facing a problem when extracting data.
We are working in a multicentre study (4 sites). We have longitudinal data on 340 subjects (expecting about 500), collected in 4 different events/CRFs. We realised we were not getting all the information from OpenClinica when downloading the dataset corresponding to one of the CRFs.
For this CRF, data has been collected using three versions of the same CRF, so we end up with a file that contains 851 variables. We download from OpenClinica all available CRFs (marked as complete and not marked as complete) in SPSS version. It takes a bit long to generate the file, but it seems to work. However, when we started working with the data, we realised there was some missing information. We could not identify the missingness pattern as it did not depend on the subject nor the CRF version. So we had some observations having empty “age” but with information on “sex” and others.
Alternatively we checked if there was any problem with the age variable, so we downloaded a dataset with this single variable and obtained all ages collected. So, we think that the problem is related to the amount of data we are trying to manage.
Has anyone encountered the same problem before? Any suggestions will be really appreciated.