Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This is an example of an ADaM dataset designed to capture the reference data describing mortality rates.

Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textAgeReqpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the left-most column in this example

STRMVAL1

Stratum 1 Value

integer
Reqpopulate with the STRTM1 values in the source data (Age in this example)
STRTM2Stratum 2

text

SexReqpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the second column in this example

STRMVAL2

Stratum 2 Value

textM;FReqpopulate with the STRTM2 values in the source data (Sex in this example)
STRTM3Stratum 3textRaceReqpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the third column in this example

STRMVAL3

Stratum 3 Value

textWHITEReqpopulate with the STRTM3 values in the source data (Race in this example)
STRTM4Stratum 4textYearReqpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the fourth column in this example

STRMVAL4

Stratum 4 Value

integer
Reqpopulate with the STRTM4 values in the source data (Year in this example)
STRTM5Stratum 5text??? need descriptor ???Reqpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the fifth column in this example

STRMVAL5

Stratum 5 Value

textDED1Reqpopulate with the STRTM1 values in the source data (Age in this example)
INPRMInput ParametertextMORTALITY PROBABILITYReqpopulate with the concept describing the value in the cell being captured in the dataset. it may come from a spreadsheet tab name, a spreadsheet name, or any desired parameter indentifying value
INPRMVALInput Parameter Valuefloat
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
reford

STRTM1

STRMVAL1

STRTM2

STRMVAL2STRTM3STRMVAL3STRTM4STRMVAL4STRTM5STRTMVAL5INPRMINPRMVALINPRMVAL
Age0SexMRaceWhiteWHITEYear2000???DED1MORTALITY PROBABILITY01
Age1SexMRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY01
Age2SexMRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY01
Age3SexMRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0011
Age4SexMRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0011
Age5SexMRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0011
Age0SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY01
Age1SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY01
Age2SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY01
Age3SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0011
Age4SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0021
Age5SexFRaceWhiteWHITEYear2000
DED1MORTALITY PROBABILITY0.0021