SLIDE 1 Michigan Questionnaire c ga Quest o a e Documentation System (MQDS): A U ’ P i A User’s Perspective
Heidi Guyer, Gina-Qian Cheung The 11th International Blaise Conference Annapolis, Maryland September 2007
SLIDE 2 MQDS Background MQDS Background
- Goal: Develop a system used to generate
Goal: Develop a system used to generate questionnaires & codebooks from a Blaise data model / data set
- Developed by the University of Michigan’s
Survey Research Center Survey Research Center
- Development Period: 2003 – 2007
- International Consortium of Users: 2006-
present p
SLIDE 3 Main features of MQDS Main features of MQDS
Core Tools
- Questionnaire Documentation
- Codebook Documentation (from Blaise BDB or
( SAS data set) Additional Tools
- XML Merge
- Reapply Stylesheet
- Blaise to SAS
- SAS to XML
SLIDE 4 Review Method Review Method
Testing to robustness
- Testing Team identified
- Testing plan developed
- Testing plan developed
- Bug Log developed
D t d l i d
- Data models assigned
- Group & Individual testing sessions
- Solicit comments from internal users
- Solicit comments from Consortium users
SLIDE 5 Overall Impressions p
y
– Flexibility – Supports multiple languages – Updated interface p
– Easy to install – Sample project provided – Updated and complete documentation – Format of output
– Limitations with large or complex data models
SLIDE 6
Program Interface Program Interface
SLIDE 7 Questionnaire Documentation Q
O t t i RTF HTML – Output in RTF or HTML – Include hyperlinks and external lookup files
– Flexibility in formatting – User selects items displayed – Supports multiple languages – Hyperlinks can be used to include other files
– Some of the screens are confusing (stylesheet selection) g ( y ) – Default color of hyperlinks and interviewer instructions is the same – Inability to display logic for large or complex data models
SLIDE 8
Questionnaire Documentation Questionnaire Documentation
SLIDE 9
Questionnaire Documentation Questionnaire Documentation
SLIDE 10 Questionnaire Documentation Questionnaire Documentation
English Spanish Tagalog Tagalog
SLIDE 11 Codebook
– Output in RTF or HTML – Output in RTF or HTML – Ability to generate a codebook from Blaise or SAS data set
Pros
– Flexibility in formatting – User selects items displayed – Supports multiple languages Supports multiple languages – Frequencies and descriptive statistics are displayed
– Same usability issues as with the Questionnaire Documentation – Inability to process extremely large data sets – Tool needed to confirm that all variables are included in the
– Codeframes will not match output for recoded or newly created SAS variables
SLIDE 12
Codebook Documentation
SLIDE 13
Demonstration Demonstration
SLIDE 14 Additional Tools
- XML Merge
- XML Merge
- Reapply Stylesheet
- Blaise to SAS
- SAS to XML
All useful time saving tools! All useful, time-saving tools!
SLIDE 15 Additional uses of MQDS Additional uses of MQDS
- Can be used throughout the project
Can be used throughout the project lifecycle:
Instrument development and testing – Instrument development and testing – Documentation IRB submission – IRB submission – Training D i d t ll ti – During data collection – Post-data collection
SLIDE 16 Additional uses of MQDS Additional uses of MQDS
- Can be used for comparison purposes:
– Across waves of a longitudinal study – Across the same study in multiple languages – Across similar studies
SLIDE 17 CPES Project CPES Project
- Collaborative Psychiatric Epidemiology
- Collaborative Psychiatric Epidemiology
Surveys (CPES)
Th NIMH t l h lth – Three NIMH mental health surveys
- National Comorbidity Survey – Replication
- National Survey of Latinos and Asian Americans
- National Survey of Latinos and Asian Americans
- National Survey of American Life
SLIDE 18 CPES Project CPES Project
- Primary goals:
- Primary goals:
– Harmonize and merge multiple datasets Di i t f bli – Disseminate for public use
SLIDE 19 Harmonization and Disclosure Analysis
D l i t t lk
- Develop survey instrument crosswalk
– Link sections and questions – Evaluate questions for comparability – Re-code questions and re-link if required for harmonization
- Merge datasets
- Perform disclosure analysis
– Re-code and drop variables – Restricted use dataset will be available [soon] [ ]
- Generate XML question metadata files (MQDS)
– Question text, response options, missing data codes, frequencies etc frequencies, etc.
SLIDE 20
CPES Home Page Overview g
www.icpsr.umich.edu/CPES
SLIDE 21
Interactive Documentation Interactive Documentation
SLIDE 22
Interactive Documentation: Frequencies / Summary Stats
SLIDE 23 Future Directions Future Directions
- Investigate incorporation of Data
Investigate incorporation of Data Dissemination Initiative (DDI) v.3 recommendations recommendations.
SLIDE 24 Summary Summary
- Useful tool for creating questionnaire and
Useful tool for creating questionnaire and data documentation
- Primary drawbacks encountered with
- Primary drawbacks encountered with
large, complex data sets
SLIDE 25
Acknowledgments Acknowledgments
ISR-SRC-SRO Tricia Blanchard, Karl Dinkelmann, Eduardo Galván, Hemant Kannan, Peter Sparks ISR-SRC Health & Retirement Study, Panel Study of Income Dynamics Dynamics MQDS Consortium Members Mathematica Policy Research National Centre for Social Mathematica Policy Research, National Centre for Social Research, Statistics Canada, UMich Survey Research Center