Download !!TOP!! Data From Redcap
Tyler Janicke
Only users identified within a project as the Information Guardian can export full deanoymised data sets from REDCap The Information Guardian is required to complete an investigator agreement on the project when that project is created within REDCap If the person listed as the Information Guardian leaves the research team, the research group are required to contact the REDCap admin and nominate a new member of staff
I am trying to export survey data from REDCap to SAS (version 9.4). After following the instructions (from REDCap) in the picture below, I opened the SAS dataset only to find that there were zero observations (i.e. no participant responses) and only variables available in the SAS dataset. However, after opening the CSV file generated by REDCap, there was no missing data. I'm not sure whether this is an issue with SAS software, or if I'm doing something wrong when exporting the data. I would greatly appreciate some insight into why SAS is reading that there are zero observations in the dataset, but the CSV file reads otherwise. Thanks!
Yes, I ran the SAS file in SAS after updating the path and no data was generated. I noticed a few errors in the log, but I'm not exactly sure what the errors mean. It seems there may be an error with the location of the CSV file, but I copied the location straight from the properties tab in "My Documents". The log is very long, so I copy and pasted lines indicating error. I hope this will suffice.
As with any data collection practice, it is always important to backup your data. Do this regularly and you will be in a much better place if anything happens to your data during the course of your research.
REDCap is a great tool but has limited analysis capabilities and you will likely want to analyze your data in another program. REDCap has a number of export settings to allow you to export data without breaking privacy rules.
For ease of analysis you can choose to export data in a variety of formats, the csv is the most widely useable, and there are versions optimized for various statistical softwares. The difference between raw data and labels versions is that the raw data has numerical data for all multiple choice questions and the labels has the text labels for those answers.
For privacy and other concerns you can choose to remove Identifier fields, hash the Record ID field (particularly useful if you renamed the Record IDs with something to keep track of participants), remove text fields, remove data and time fields, and remove survey timestamps. If you choose to shift all dates instead of excluding dates, note that each Record will have their dates shifted by a random amount.
The University of Washington (UW) Health Sciences Library (HSL) has supported REDCap at the UW since December 2016. At UW HSL, we use REDCap for room reservations and statistics tracking, and we provide basic technical support for the UW community and UW affiliates. To reserve a room, a library client fills out a REDCap survey, which the library receives via email with the room reservation request. The room reservation request is then uploaded into an online ticketing system so that a librarian can accept the ticket and assist the library user with the room request. At the end of the month, a librarian logs into REDCap to analyze the room reservation requests and exports the data to Microsoft Excel.
Library staff also use a REDCap survey to keep track of reference questions and literature reviews for departments that are not covered under our education and reference tracking system. Features that we use at UW HSL include branching logic for survey question design, project calendars and schedules to send out notices for events, and data export.
I have a survey in REDCap. Some of the participants were completed the survey without attending an event. When I export the data I am required to get the data without those participants every time automatically. Could anyone please help me to do it? Thanks in advance.I am not supposed to delete their response on REDCap.
It isn't clear from your question what 'event' refers to. If it is a REDCap longitudinal event, then you might want to rely on, say, the completion of the last form in that event. If the event is [event_1_arm_1] and the last instrument on that event is [final_survey], then you could rely on the value of [event_1_arm_1][final_survey_complete]. If they have completed the 'final survey', then this value will be 2. If they haven't, then it will be not 2.
Any data that does not conform to your configuration will be flagged. A list of how to resolve the issues with the import will be provided. No data will be imported until the conflicts have been resolved.
Alternatively, you can create a report that only displays specific instruments. Again from the Data Exports, Reports and Stats link (under Applications), you could choose "Make custom selections" instead:
To include data from the Enrollment event, use calculated fields to copy missing values across events. In this example, we want to add the School ID variable from the Enrollment to the Test 1 instrument.
After adding calculated fields to an instrument that already has data, use the Data Quality tool (in the Applications menu) to force these values to be calculated or recalculated in the existing records. Choose the Execute option for the "Incorrect values for calculated fields" rule to see a report of affected records. If there are any incorrectly calculated fields - as there should be after we added these new variables - they will be listed in the Total Discrepancies column.
These examples are intended to illustrate one way to display record data across events for a longitudinal project in REDCap. There are many ways of doing this, especially outside the REDCap project. However, if the data need to be aggregated directly in REDCap, this concept provides a way achieve the same effect as merging separate one-to-many files into a single report.
REDCap-ETL (REDCap Extract, Transform, Load) extracts data from REDCap, transforms it into a relational format, and loads that data to a relational database or, if run as standalone software, to an SQLite file or a series of CSV files. REDCap-ETL can be run within IU REDCap or as standalone software.
If the IU REDCap project data you are accessing contain protected health information (PHI), you must treat the data as PHI, which means files must be encrypted when they are stored (at rest) and when they are transferred from one system to another (in transit). For more, see:
If you have questions about securing HIPAA-regulated research data at IU, email securemy...@iu.edu. SecureMyResearch provides self-service resources and one-on-one consulting to help IU researchers, faculty, and staff meet cybersecurity and compliance requirements for processing, storing, and sharing regulated and unregulated research data; for more, see About SecureMyResearch. To learn more about properly ensuring the safe handling of PHI on UITS systems, see the UITS IT Training video Securing HIPAA Workflows on UITS Systems. To learn about division of responsibilities for securing PHI, see Shared responsibility model for securing PHI on UITS systems.
A REDCap-ETL interface is available within IU REDCap as an external module. The REDCap-ETL external module provides a graphical interface for configuring REDCap-ETL, enables REDCap-ETL to be scheduled, and can generate at the press of a button the transformation rules needed by REDCap-ETL to define how to transform REDCap data into a relational format.
The REDCap-ETL external module allows data to be loaded into relational databases such as MySQL, PostgreSQL, and SQL Server, and to be downloaded interactively as a set of CSV files. When downloading CSV files, the REDCap-ETL external module cannot be scheduled.
REDCap-ETL can be run as standalone software. Doing so requires a server to host REDCap-ETL. The REDCap-ETL configuration, including the transformation rules that define how to transform REDCap data into a relational format, must be manually created. Automating REDCap-ETL as standalone software requires using your server's scheduling functionality.
REDCap is a free, secure, web-based application designed to support data capture for research studies. The system was developed by a multi-institutional consortium initiated at Vanderbilt University. Data collection is customized for each study or clinical trial by the research team with guidance from Harvard Catalyst EDC Support Staff. REDCap is designed to comply with HIPAA regulations. REDCap is not 21 CFR Part 11 compliant.
REDCap provides user-friendly web-based case report forms, real-time data entry validation (e.g. for data types and range checks), audit trails, and the ability to set up a calendar to schedule and track critical study events such as blood-draws, participant visits, etc. Also, designated users can assign different levels of access for each member of the research team.
You will next need to choose which records to send. It is recommended that you send 'New/Modified Only' since those records are typically the only information that is not already in your REDCap project on the server. Sending 'All Records' should be used if you are uncertain which data should be sent. 'Select records manually' will allow you to pick and choose specific records to send.
9738318194