This is an example of an ADaM dataset designed to capture the reference data describing historical transitional probabiitiesprobabilities. When there are two products in the TOBACCO PRODUCT CATEGORY there are 27 different possible transitions. In the example data below, STRTM4 captures the combination of tobacco products of interest for this particular set of probabilities and STRTM5 captures the status of product(s) of interest pre-transition. STRTM6 captures the transition type of the combination of usage at the point of probability and STRTM7 captures the status of product(s) of interest post-transition.
| Dataset wrap |
|---|
|
| Rowcaps |
|---|
| Row 1: | Shows INITIATION of both products going from NEVER/NEVER to CURRENT/CURRENT. | | Row 2: | Shows CESSATION of both products going from CURRENT/CURRENT to FORMER/FORMER. | | Row 3: | Shows RELAPSE of both products going from FORMER/FORMER to CURRENT/CURRENT. | | Rows 4-27: | Show various combinations and pathways of transitional probabilities that are captured in the historical data. |
|
| Dataset2 |
|---|
| STRTM3| STRTM4 | STRVAL4 | STRTM5 | STRVAL5 | STRTM6 | STRVAL6 | STRTM7 | STRVAL7 | INPRM | INPRMVAL | INPRMU |
|---|
|
YearAge0Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE |
Init| INITIATION | TOBACCO PRODUCT |
Cigarettes| USE STATUS POST-TRANSITION | CURRENT/CURRENT | TRANSITION PROBABILITY | 0.15 | RATIO / 10 PER 1000 | | 2 |
YearAge1Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE |
Init| USE STATUS POST-TRANSITION | FORMER/FORMER |
Cigarettes | TRANSITION PROBABILITY | 0.03 | RATIO / 10 PER 1000 | | 3 |
YearAge2Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Init| USE STATUS POST-TRANSITION | CURRENT/CURRENT |
Cigarettes | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 4 |
YearAge3Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE |
Init| INITIATION | TOBACCO PRODUCT |
| USE STATUS POST-TRANSITION | NEVER/CURRENT |
Cigarettes | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 5 |
YearAge4Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE |
Init| USE STATUS POST-TRANSITION | CURRENT/FORMER |
Cigarettes | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 6 |
YearAge0Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE |
Quit| USE STATUS POST-TRANSITION | NEVER/FORMER |
Cigarettes0001YearAge1Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Quit| USE STATUS POST-TRANSITION | FORMER/CURRENT |
Cigarettes0001YearAge2Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Quit| USE STATUS POST-TRANSITION | FORMER/FORMER |
Cigarettes0001YearAge3Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Quit| USE STATUS POST-TRANSITION | CURRENT/FORMER |
Cigarettes0001YearAge4Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Quit| USE STATUS POST-TRANSITION | CURRENT/CURRENT |
Cigarettes0001YearAge0Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE |
Relapse| USE STATUS POST-TRANSITION | CURRENT/FORMER |
Cigarettes0001YearAge1Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Relapse| INITIATION | TOBACCO PRODUCT |
| USE STATUS POST-TRANSITION | CURRENT/FORMER |
Cigarettes0001YearAge2Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Relapse| USE STATUS POST-TRANSITION | NEVER/CURRENT |
Cigarettes0001YearAge3Sex| SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE |
Relapse| USE STATUS POST-TRANSITION | CURRENT/CURRENT |
Cigarettes0001Year | 2000 | Age | 4 | Sex | F | TRANSITION TYPE | Relapse | PRODUCT | | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | INITIATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/NEVER | TRANSITION PROBABILITY | 0.01 | RATIO / 10 PER 1000 | | 16 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | SWITCHING | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/CURRENT | TRANSITION PROBABILITY | 0.03 | RATIO / 10 PER 1000 | | 17 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | CESSATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/NEVER | TRANSITION PROBABILITY | 0.04 | RATIO / 10 PER 1000 | | 18 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | RELAPSE | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/CURRENT | TRANSITION PROBABILITY | 0.03 | RATIO / 10 PER 1000 | | 19 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | RELAPSE | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/NEVER | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 20 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | INITIATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/CURRENT | TRANSITION PROBABILITY | 0.05 | RATIO / 10 PER 1000 | | 21 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE | RELAPSE | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/CURRENT | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 22 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE | CESSATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/FORMER | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 23 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/FORMER | TOBACCO PRODUCT USE TRANSITION TYPE | RELAPSE | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/CURRENT | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 24 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/NEVER | TOBACCO PRODUCT USE TRANSITION TYPE | INITIATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/CURRENT | TRANSITION PROBABILITY | 0.01 | RATIO / 10 PER 1000 | | 25 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | CURRENT/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE | CESSATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | FORMER/CURRENT | TRANSITION PROBABILITY | 0.01 | RATIO / 10 PER 1000 | | 26 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | NEVER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE | INITIATION | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/CURRENT | TRANSITION PROBABILITY | 0.02 | RATIO / 10 PER 1000 | | 27 | YEAR | 2000 | AGE | 24 | SEX | F | TOBACCO PRODUCT CATEGORY | CIGARETTE/CIGAR | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | FORMER/CURRENT | TOBACCO PRODUCT USE TRANSITION TYPE | SWITCHING | TOBACCO PRODUCT USE STATUS POST-TRANSITION | CURRENT/FORMER |
Cigarettes0001 |
|
| Definexmltable |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
| OID | RFTRANSP |
|---|
| Name | RFTRANSP |
|---|
|
| Dataset | Description | Class | Structure | Purpose | Keys | Location | Documentation |
|---|
| RFTRANSP | Reference Data for Transition Prob | REFERENCE DATA STRUCTURE | one record per input value | reference | STRTM1, STRM2, STRTM3, STRTM4 STRTM5 STRTM6 STRTM7 | rftransp.xpt | NA |
|
| Definexmltable |
|---|
| Dataset | RFTRANSP |
|---|
| Level | Variable |
|---|
| Purpose | Analysis |
| Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Notes |
|---|
| STRTM1 | Stratum 1 | text |
|---|
| YEAR | 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 | | | text |
| Req | populate with the STRTM1 values in the source data (Age in this example) |
|---|
| STRTM2 | Stratum 2 | text |
|---|
| AGE | Cond | populate 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 | | | text |
|---|
|
| Cond | populate with the STRTM2 values in the source data (F in this example for displayed data) | | STRTM3 | Stratum 3 | text |
|---|
| SEX | Cond | populate 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 | | | text |
|---|
| F | Cond | populate with the STRTM3 values in the source data (Transition Type 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) - the third part of the second column concept in this example |
|---|
| | text |
|---|
| STRTM4 values in the source data (Product in this example) | | STRTM5 | Stratum 5 | text | TOBACCO PRODUCT USE STATUS PRE-TRANSITION | Cond | populate 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 |
|---|
| | text | CURRENT/CURRENT;CURRENT/FORMER;CURRENT/NEVER;FORMER/CURRENT;FORMER/FORMER;FORMER/NEVER;NEVER/CURRENT;NEVER/FORMER;NEVER/NEVER | Cond | populate with the STRTM5 values in the source data (Transition Type in this example) |
|---|
| STRTM6 | Stratum 6 | text | TOBACCO PRODUCT USE TRANSITION TYPE | Cond | populate 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 |
|---|
| | text | INITIATION;CESSATION;SWITCHING;RELAPSE | Cond | populate with the STRTM6 values in the source data (Transition Type in this example) |
|---|
| STRTM7 | Stratum 7 | text | TOBACCO PRODUCT USE STATUS POST-TRANSITION | Cond | populate 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 |
|---|
| | text | CURRENT/CURRENT;CURRENT/FORMER;CURRENT/NEVER;FORMER/CURRENT;FORMER/FORMER;FORMER/NEVER;NEVER/CURRENT;NEVER/FORMER
| Cond | populate with the STRTM7 values in the source data (Transition Type in this example) |
|---|
| INPRM | Input Parameter | text | TRANSITION 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 |
|---|
| INPRMU | Input Parameter Unit | text | RATIO / 10 PER 1000 | Perm | populate with the unit describing the cell values if appropriate |
|---|
|