Page History

This is an example of an ADaM dataset

Jira
showSummary false server Issue Tracker (JIRA) serverId 85506ce4-3cb3-3d91-85ee-f633aaaf4a45 key TOBA-652

designed to capture the reference data describing historical transitional probabilities. 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  interest post-transition.The rows 1-3 then follow the different probabilities of transitions following pathways:

Dataset wrap
Name RFTRANSP
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.
Dataset wrap
Name RFTRANSP
Dataset2 tableid rftransp.xpt Row STRTM1 STRVAL1 STRTM2 STRVAL2 STRTM3 STRVAL3 STRTM4 STRVAL4 STRTM5 STRVAL5 STRTM6 STRVAL6 STRTM7 STRVAL7 INPRM INPRMVAL INPRMU 1 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/NEVER TOBACCO PRODUCT USE TRANSITION TYPE INITIATION TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/CURRENT TRANSITION PROBABILITY 0.15 RATIO / 10 PER 1000 2 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/CURRENT TOBACCO PRODUCT USE TRANSITION TYPE CESSATION TOBACCO PRODUCT USE STATUS POST-TRANSITION FORMER/FORMER TRANSITION PROBABILITY 0.03 RATIO / 10 PER 1000 3 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION FORMER/FORMER TOBACCO PRODUCT USE TRANSITION TYPE RELAPSE TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/CURRENT TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 4 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/NEVER TOBACCO PRODUCT USE TRANSITION TYPE INITIATION TOBACCO PRODUCT USE STATUS POST-TRANSITION NEVER/CURRENT TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 5 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/CURRENT TOBACCO PRODUCT USE TRANSITION TYPE SWITCHSWITCHING TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/FORMER TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 6 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/CURRENT TOBACCO PRODUCT USE TRANSITION TYPE CESSATION TOBACCO PRODUCT USE STATUS POST-TRANSITION NEVER/FORMER TRANSITION PROBABILITY 0.06 RATIO / 10 PER 1000 7 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/FORMER TOBACCO PRODUCT USE TRANSITION TYPE SWITCHSWITCHING TOBACCO PRODUCT USE STATUS POST-TRANSITION FORMER/CURRENT TRANSITION PROBABILITY 0.03 RATIO / 10 PER 1000 8 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/FORMER TOBACCO PRODUCT USE TRANSITION TYPE CESSATION TOBACCO PRODUCT USE STATUS POST-TRANSITION FORMER/FORMER TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 9 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION FORMER/FORMER TOBACCO PRODUCT USE TRANSITION TYPE RELAPSE TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/FORMER TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 10 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/FORMER TOBACCO PRODUCT USE TRANSITION TYPE RELAPSE TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/CURRENT TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 11 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/CURRENT TOBACCO PRODUCT USE TRANSITION TYPE CESSATION TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/FORMER TRANSITION PROBABILITY 0.01 RATIO / 10 PER 1000 12 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/FORMER TOBACCO PRODUCT USE TRANSITION TYPE INITIATION TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/FORMER TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 13 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/FORMER TOBACCO PRODUCT USE TRANSITION TYPE RELAPSE TOBACCO PRODUCT USE STATUS POST-TRANSITION NEVER/CURRENT TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 14 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION NEVER/FORMER TOBACCO PRODUCT USE TRANSITION TYPE RELAPSE TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/CURRENT TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000 15 YEAR 2000 AGE 24 SEX F TOBACCO PRODUCT CATEGORY CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION CURRENT/NEVER TOBACCO PRODUCT USE TRANSITION TYPE SWITCHSWITCHING 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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/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 CIGARETTESCIGARETTE/CIGAR TOBACCO PRODUCT USE STATUS PRE-TRANSITION FORMER/CURRENT TOBACCO PRODUCT USE TRANSITION TYPE SWITCHSWITCHING TOBACCO PRODUCT USE STATUS POST-TRANSITION CURRENT/FORMER TRANSITION PROBABILITY 0.02 RATIO / 10 PER 1000

...

Definexmltable
Dataset RFTRANSP Custom true Level Variable Name RFTRANSP
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 STRVAL1 Stratum 1 Value 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 STRVAL2 Stratum 2 Value 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 STRVAL3 Stratum 3 Value 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 STRVAL4 Stratum 4 Value text CIGARETTES CIGARETTE/CIGAR Cond populate with the 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 STRVAL5 Stratum 5 Value 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 STRVAL6 Stratum 6 Value text INITIATION;CESSATION; SWITCH 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 STRVAL7 Stratum 7 Value 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