This is an example of an ADaM dataset designed to capture the reference data describing mortality rates.
| Dataset wrap |
|---|
|
| Dataset2 |
|---|
| | STRVAL1 | | STRVAL2 | STRTM3 | STRVAL3 | STRTM4 | STRVAL4 | STRTM5 | STRVAL5 | INPRM | INPRMVAL |
|---|
| 1 | AgeAGE | 0 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 2 | AgeAGE | 1 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 3 | AgeAGE | 2 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 4 | AgeAGE | 3 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.001 | | 5 | AgeAGE | 4 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.001 | | 6 | AgeAGE | 5 | SexSEX | M | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.001 | | 7 | AgeAGE | 0 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 8 | AgeAGE | 1 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 9 | AgeAGE | 2 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0 | | 10 | AgeAGE | 3 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.001 | | 11 | AgeAGE | 4 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.002 | | 12 | AgeAGE | 5 | SexSEX | F | RaceRACE | WHITE | YearYEAR | 2000 | PRODUCT COMPARATORS | DEP1 | MORTALITY PROBABILITY | 0.002 |
|
|
| Definexmltable |
|---|
| Variable |
| 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 |
|