Versions Compared

Key

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

...

Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textyearReqpopulate 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

STRMVAL1STRVAL1

Stratum 1 Value

integer??
Reqpopulate with the STRTM1 values in the source data (years 2000-2050 in this example)
STRTM2Stratum 2

text

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

STRMVAL2STRVAL2

Stratum 2 Value

textM;FCondpopulate with the STRTM2 values in the source data (M/F in this example for displayed data)
STRTM3Stratum 3textRaceCondpopulate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the second part of the second column concept in this example

STRMVAL3STRVAL3

Stratum 3 Value

textTotal;WhiteCondpopulate with the STRTM3 values in the source data (Race in this example)
INPRMInput ParametertextBIRTH RATEReqpopulate 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
INPRMUInput Parameter Unittext

RATIO / 10 PER 1000

Permpopulate with the unit describing the cell values if appropriate

...

question - ??? case for STRTMy?? use SDTM variables/CT if relevant??

STRTM1

STRMVAL1STRVAL1

STRTM2

STRMVAL2STRVAL2STRTM3STRMVAL3STRVAL3INPRMINPRMVALINPRMU
year2000SexFRaceTotalBIRTH RATE

0.048156602

RATIO / 10 PER 1000

year

2001

SexFRaceTotalBIRTH RATE0.050162384RATIO / 10 PER 1000
year2002SexFRaceTotalBIRTH RATE0.049912072RATIO / 10 PER 1000
year2003SexFRaceTotalBIRTH RATE0.049953214RATIO / 10 PER 1000
year2004SexFRaceTotalBIRTH RATE0.050199534RATIO / 10 PER 1000
year2000

Sex

M

RaceTotalBIRTH RATE0.050497803RATIO / 10 PER 1000
year

2001

SexMRaceTotalBIRTH RATE0.052554053RATIO / 10 PER 1000
year2002SexMRaceTotalBIRTH RATE0.052289152RATIO / 10 PER 1000
year2003SexMRaceTotalBIRTH RATE0.052334712RATIO / 10 PER 1000
year2004SexMRaceTotalBIRTH RATE0.052594772RATIO / 10 PER 1000
year2000SexFRaceWhiteBIRTH RATE0.043829866RATIO / 10 PER 1000
year

2001

SexFRaceWhiteBIRTH RATE0.04509937RATIO / 10 PER 1000
year2002SexFRaceWhiteBIRTH RATE0.044711283RATIO / 10 PER 1000
year2003SexFRaceWhiteBIRTH RATE0.044899939RATIO / 10 PER 1000
year2004SexFRaceWhiteBIRTH RATE0.045284915RATIO / 10 PER 1000

...