MORGAM Manual

Data transfer format: Case and subcohort selection data Form: 65 Version: 2 Date: 2007-05-21

© National Institute for Health and Welfare and the MORGAM Project investigators Last updated: 18 November 2008 For more information, please contact Zygimantas Cepaitis (firstname.lastname@thl.fi) or Kari Kuulasmaa (firstname.lastname@thl.fi)

The purpose of this form is to provide a format for the transfer of data from the selection of cases and subcohort to MORGAM database. Data in the format specified here are provided for every member of each MORGAM cohort for which the selection of cases and the subcohort has been done. The MORGAM case-cohort design is described in sections "Selection of cases and cohort subsample" and "Subsample selection after extension of follow-up" of the Manual.

This format should not be used for transferring data from the MORGAM Participating Centres to the MORGAM Data Centre (MDC), because these data are generated by the MDC.

Contents

• Format specification
• Data transfer procedures
• Specific comments on each item

Format specification

Columns of the format specification

ITEM NAME

name used for the item in the MDC.

SPECIFICATION AND CODES

specification and values of the variable. More details can be found in the section "Definitions of the variables" below, or by following the hyperlink in column ITEM NAME.

FORMAT OR VALUE

specifies the format in which the value should be presented in the transfer data set. In the cases where the value of the variable is fixed, the value is also given in this column.

FORMAT	Type	Format	Example	Comments
C	Character	C7	SWE-NSWa	RUA abbreviation used in MORGAM.
		C2	03	Cohort identification
F	Float	F5.2	13.1	Variable includes a decimal point (.).
R	Real number	R	0.24927345	Selection probability.
I	Integer	I5	221 10323

Data transfer procedures

The data files shall be prepared in ASCII comma-delimited format using semicolon (;) as the delimiter, with the names of the variables in the first row.

Specific comments on each item

Follow these instructions carefully when creating the computer file for data transfer. Any exceptions to these coding rules must be documented in the Case and subcohort selection report in the internal MORGAM web site.

Number 65 indicates the "Data transfer format: Case and subcohort selection data".

This indicates the version number of this data transfer format entitled "Data transfer format: Case and subcohort selection data".

This is a unique sequence number which identifies the selection of cases and subcohorts of this transfer set. The first ever selection has value 001, the second 002 etc. Gaps are not allowed in the numbering. For each selection, a report with the same SELECTION number has to be prepared in the internal MORGAM web site.

Item SELECTION must have the same value for every record in this data transfer set.

The selection of cases and subcohort can be supplemented later, for example due to extension of the follow-up period of a MORGAM cohort.

Each time when there are changes to the case-cohort selection for a RUNIT/COHORT combination, the PHASE value is increased to the next unused value within the cohorts being considered. Item PHASE must have the same value for every record in this data transfer set. (If, for any reason, the highest earlier PHASE-value varied between the cohorts considered, there will be gaps for the sequence of the PHASE values for some cohorts. This does not matter.)

The first four numbers indicate the year, the next two the month and the last two the day of month.

Item DATE must have the same value for every record in this data transfer set.

These are key items used for identifying the record and merging it with other records of the same individual.

CENTRE is the official MORGAM Participating Centre code number, RUNIT the official MORGAM Reporting Unit code number and COHORT the official MORGAM Cohort code number as they appear in section "MORGAM Participating Centres and cohorts" of the MORGAM Manual.

SERIAL is the identification for the individual. It is unique within the combination of CENTRE, RUNIT and COHORT.

The eligibility of the person to the subcohort requires that

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2, AND
• item CONSSTR of Form 21 has value 1 or 2.

This is the selection probability for the individual to the subcohort, i.e. the marginal probability on which the person is in the cohort subsample. The sampling weights for data analysis in the case-cohort design are derived from item PROB and the case status, which depends on the definition of the end-point for each analysis.

This item indicates whether the individual belongs to the subcohort or not.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2, AND
• item CONSSTR of Form 21 has value 1 or 2; AND
• item EXREAS of Form 25 has value 1.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2; AND
• item DGNCAT of Form 22 has value 1, 2, 3, 4, 5 or 6, OR item EVTYPE of Form 22 has value 2 or 4.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSSTR of Form 21 has value 1 or 2; AND
• item DGNCAT of Form 23 has value 1 or 9.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSTED of Form 21 has value 1 or 2; AND
• item VTETYPE of Form 26 has value 1 or 2.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2; AND
• item EVTYPE of Form 22 has value 1.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2, AND
• item CONSSTR of Form 21 has value 1 or 2; AND
• at least one of items HISMI1, HISMI2, HISREV1 or HISREV2 of Form 21 has value 1.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

The general  selection criteria are:

• the information on smoking, blood pressure, cholesterol and DNA are available (see Appendix 1 of the section Selection of cases and cohort subsample for details); AND
• item DNAAV of Form 21 has value 1; AND
• item CONSCHD of Form 21 has value 1 or 2, AND
• item CONSSTR of Form 21 has value 1 or 2; AND
• at least one of items HISSTR1 or HISSTR2 of Form 21 has value 1.

Code 1 if the general selection criteria were met and the person was selected because of these.

Code 2 if the general selection criteria were not met.

Code 3 if the general selection criteria were met but the person was not selected because of these. The decision for not selecting the person must be described in the Case and subcohort selection report.

Updates