This is an example of an ADaM dataset designed to capture the reference data describing mortality rates.
$titleHtml
xx.xpt
Row
STRTM1
STRVAL1
STRTM2
STRVAL2
STRTM3
STRVAL3
STRTM4
STRVAL4
STRTM5
STRVAL5
INPRM
INPRMVAL
1
AGE
0
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
2
AGE
1
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
3
AGE
2
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
4
AGE
3
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.001
5
AGE
4
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.001
6
AGE
5
SEX
M
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.001
7
AGE
0
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
8
AGE
1
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
9
AGE
2
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0
10
AGE
3
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.001
11
AGE
4
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.002
12
AGE
5
SEX
F
RACE
WHITE
YEAR
2000
PRODUCT COMPARATORS
DEP1
MORTALITY PROBABILITY
0.002
$warningHtml
RFMORT Dataset Metadata
Dataset
Description
Class
Structure
Purpose
Keys
Location
Documentation
RFMORT
Reference Data for Mortality Rates
REFERENCE DATA STRUCTURE
one record per input value
reference
STRTM1, STRM2, STRTM3, STRTM4, STRTM5
rfmort.xpt
NA
ADXX Variable Metadata
Variable Name
Variable Label
Type
Codelist/Controlled Terms
Core
Notes
STRTM1
Stratum 1
text
Age
Req
populate 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
STRVAL1
Stratum 1 Value
integer
Req
populate with the STRTM1 values in the source data (Age in this example)
STRTM2
Stratum 2
text
Sex
Req
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the second column in this example
STRVAL2
Stratum 2 Value
text
M;F
Req
populate with the STRTM2 values in the source data (Sex in this example)
STRTM3
Stratum 3
text
Race
Req
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the third column in this example
STRVAL3
Stratum 3 Value
text
WHITE
Req
populate with the STRTM3 values in the source data (Race in this example)
STRTM4
Stratum 4
text
Year
Req
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the fourth column in this example
STRVAL4
Stratum 4 Value
integer
Req
populate with the STRTM4 values in the source data (Year in this example)
STRTM5
Stratum 5
text
PRODUCT COMPARATORS
Req
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the fifth column in this example
STRVAL5
Stratum 5 Value
text
DED1
Req
populate with the STRTM5 values in the source data
INPRM
Input Parameter
text
MORTALITY PROBABILITY
Req
populate 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
INPRMVAL
Input Parameter Value
float
Req
populate with the cell value from the referenced data that is being described by the STRMVALy values