Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • CDMS
  • Castor CDMS Manual
  • Export data
  • Participant Data

Merge study and repeating data/survey data files in SPSS in CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • CDMS
    Castor CDMS Manual Castor CDMS Calculations Manual Frequently Asked Questions Articles for Data Managers Castor CDMS Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents Castor Connect Manual Castor Connect - Participant Quick Start Guide
  • Helpdesk
    News Other Resources Castor products knowledge resources
  • Status page
  • Completing a Study
+ More

Table of Contents

Restructure repeating data/survey data to wide format 2. Merge study data and repeating data/survey data

Before you follow the steps in this article, please make sure you have exported your data properly. See here how you can export to SPSS. Save your .sav files, e.g. 'studydata.sav' and 'reports_bloodpressure.sav'.

 

If you want to merge files in a wide format (i.e., for every repeating data/survey instance, new columns are added), follow the steps below for '1. Restructure repeating data to wide format'. If you want to merge files in a long format (i.e., for every report/survey instance, a row is added for a record), skip to '2. Merging study data and report/survey data'.

Restructure repeating data/survey data to wide format

  1. Open your repeating data or survey file. In this example we'll use the repeating data file 'report_bloodpressure.sav'.

Click Data > Restructure

Select 'Restructure selected cases into variables'. Click Next.

Select 'record_id' ('participant_id') as Identifier Variable. Click Next.

Select Yes for 'Sort the current data?'. Click Finish. Every repeating data/survey variable will have a suffix '.X' with X being the number of the report/survey instance.

To merge your study and repeating data/survey data, follow the steps below from 'Merge study data and repeating data/survey data'.

2. Merge study data and repeating data/survey data

  1. Let's say you want to merge the .sav files 'studydata.sav' and 'reports_bloodpressure.sav'.
  2. Make sure you sort the column ‘record_id’ ('participant_id') in both files:
    • Right click on the name of the column.
    • Click 'Sort Ascending'.
  3. Open 'studydata.sav'.
  4. Click 'Data' > 'Merge files' > 'Add variables'.
  5. Select the dataset you want to merge, so e.g. 'reports_bloodpressure.sav'. Click 'Continue'.
  6.  Select:
    • 'Match cases on key variables'
    • 'Cases are sorted in order of key variables in both datasets'
    • 'Both files provide cases'
    • Select 'record_id'('participant_id') as key variable.
  7. Click 'OK'.
merge spss

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Import study data in CDMS
  • Export and merge data in R in CDMS
  • Import repeating data in CDMS
  • Export uploaded files in CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media


Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand