This is an example of an ADaM dataset designed to capture the reference data describing mortality rates.
...
...
...
...
| STRVAL3 | STRTM4 | STRVAL4 | STRTM5 |
|---|
|
|
...
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
...
| PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0.001 |
|
|
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0.001 |
|
|
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0.001 |
|
|
...
...
...
...
...
...
...
| PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
...
| PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
| YEAR | 2000 | PRODUCT COMPARATORS |
|
|
...
| DEP1 | MORTALITY PROBABILITY | 0 |
|
|
...
...
...
...
...
...
...
| PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.001 |
|
|
...
...
| AGE | 4 | SEX | F | RACE | WHITE | YEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.002 | | 12 | AGE | 5 | SEX |
|
|
...
...
...
...
...
| PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.002 |
|
|
| Definexmltable |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
|
| 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 |
|
| Definexmltable |
|---|
| Dataset | RFMORT |
|---|
| Level | Variable |
|---|
|
| 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 |
|
...