This is an example of an ADaM dataset designed to capture reference data describing the initial population.
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Rows 1-6: | Show the counts of subjects in each combination of the population and therefore only STRTM1/STRTM2/STRM3 are populated in the example. These counts are independent of any tobacco usage (or non-usage) and therefore STRTM4/STRVAL4 and STRTM5/STRVAL5 columns are null. The INPRM value contains the concept captured in INPRMVAL and INPRMU captures the unit of the INPRMVAL value. | | Rows 7-15: | Show initial tobacco usage status for several product combinations and the prevalence of each usage status. |
|
| Dataset2 |
|---|
| | | STRVAL1 | | STRVAL2 | STRTM3 | STRVAL3 | STRTM4 | STRVAL4 | STRTM5 | STRVAL5 | INPRM | INPRMVAL | INPRMU | REFSRCE |
|---|
| 1 | AGE | 0 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 50 | COUNT | initial population 2017.xlsx | | 2 | AGE | 10 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 48 | COUNT | initial population 2017.xlsx | | 3 | AGE | 20 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 49 | COUNT | initial population 2017.xlsx | | 4 | AGE | 30 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 50 | COUNT | initial population 2017.xlsx | | 5 | AGE | 40 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 51 | COUNT | initial population 2017.xlsx | | 6 | AGE | 50 | SEX | M | RACE | WHITE |
|
|
|
| POPULATION COUNT | 52 | COUNT | initial population 2017.xlsx | | 7 | AGE | 0 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | NEVER | PREVALENCE | 70 | PERCENT | initial population 2017.xlsx | | 8 | AGE | 10 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | NEVER | PREVALENCE | 68 | PERCENT | initial population 2017.xlsx | | 9 | AGE | 20 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | CURRENT | PREVALENCE | 10 | PERCENT | initial population 2017.xlsx | | 10 | AGE | 30 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | CURRENT | PREVALENCE | 14 | PERCENT | initial population 2017.xlsx | | 11 | AGE | 40 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | FORMER | PREVALENCE | 16 | PERCENT | initial population 2017.xlsx | | 12 | AGE | 50 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE | TOBACCO PRODUCT USE STATUS | FORMER | PREVALENCE | 17 | PERCENT | initial population 2017.xlsx | | 13 | AGE | 20 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE/ENDS | TOBACCO PRODUCT USE STATUS | FORMER/CURRENT | PREVALENCE | 20 | PERCENT | initial population 2017.xlsx | | 14 | AGE | 30 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE/ENDS | TOBACCO PRODUCT USE STATUS | FORMER/CURRENT | PREVALENCE | 25 | PERCENT | initial population 2017.xlsx | | 15 | AGE | 40 | SEX | M | RACE | WHITE | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS | CURRENT/CURRENT | PREVALENCE | 10 | PERCENT | initial population 2017.xlsx |
|
|
| Definexmltable |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
|
| Dataset | Description | Class | Structure | Purpose | Keys | Location | Documentation |
|---|
| RFIP | Reference Data for Initial Population | REFERENCE DATA STRUCTURE | one record per input value | reference | STRTM1, STRM2, STRTM3, STRTM4, STRTM5 | rfip.xpt | N/A |
|
| Definexmltable |
|---|
|
| 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 | text |
| Req | populate with the STRTM1 values in the source data (Age in this example) | | STRTM2 | Stratum 2 | text | SEX | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the lower level of the fifth column in this example | | STRVAL2 | Stratum 2 Value | text | M;F | Cond | populate with the STRTM2 values in the source data (Sex in this example) | | STRTM3 | Stratum 3 | text | RACE | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the upper level of the fifth column in this example | | STRVAL3 | Stratum 3 Value | text | WHITE | Cond | populate with the STRTM3 values in the source data (Race in this example) | | STRTM4 | Stratum 4 | text | TOBACCO PRODUCT CATEGORY | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) | | STRVAL4 | Stratum 4 Value | text | CIGARETTE;CIGARETTE/ENDS;CIGARETTE/CIGAR | Cond | populate with the STRTM4 values in the source data | | STRTM5 | Stratum 5 | text | TOBACCO PRODUCT USE STATUS | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) | | STRVAL5 | Stratum 5 Value | text | NEVER;CURRENT;FORMER;FORMER/CURRENT;CURRENT/CURRENT | Cond | populate with the STRTM5 values in the source data | | INPRM | Input Parameter | text | POPULATION COUNT;PREVALENCE | 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 identifying value | | INPRMVAL | Input Parameter Value | float |
| Req | populate with the cell value from the referenced data that is being described by the STRMVALy values | | INPRMU | Input Parameter Unit | text | | Perm | populate with the unit describing the cell values if appropriate | | REFSRCE | Reference Data Source |
|
...
| text | initial population 2017.xlsx | Perm | populate with the file that is the source of the reference data (the same columns and rows will change over time so identifying the source allows for traceability) |
|