Page History

This is an example of an ADaM dataset 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 at the time of first set of probabilitiesinterest pre-transition. STRTM6 captures the transition type of the combination of usage at the point of probability and STRTM7 captures the actual combination of usage at the point of probability

The rows 1-3 then follow the different probabilities of transitions following pathway "e" to "p" to "e" (NEVER/NEVER to CURRENT/CURRENT to FORMER/FORMER).

...

status of product(s) of interest post-transition.

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/NEVER	TRANSITION PROBABILITY	0.0102	RATIO / 10 PER 1000
5	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	NEVER/CURRENT/NEVER	TOBACCO PRODUCT USE TRANSITION TYPE	INITIATIONSWITCHING	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/CURRENTFORMER	TRANSITION PROBABILITY	0.0102	RATIO / 10 PER 1000
6	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENTNEVER/CURRENT	TOBACCO PRODUCT USE TRANSITION TYPE	CESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	NEVER/FORMER/CURRENT	TRANSITION PROBABILITY	0.0106	RATIO / 10 PER 1000
7	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENT/CURRENTFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	CESSATIONSWITCHING	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMER/CURRENT/FORMER	TRANSITION PROBABILITY	0.0103	RATIO / 10 PER 1000
8	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	NEVERCURRENT/NEVERFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	INITIATIONCESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	NEVERFORMER/CURRENTFORMER	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	NEVERFORMER/CURRENTFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	INITIATIONRELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/CURRENTFORMER	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	NEVERCURRENT/CURRENTFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	SWITCHINGRELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/FORMERCURRENT	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	NEVERCURRENT/CURRENT	TOBACCO PRODUCT USE TRANSITION TYPE	CESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	NEVERCURRENT/FORMER	TRANSITION PROBABILITY	0.0601	RATIO / 10 PER 1000
12	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENTNEVER/NEVERFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	CESSATIONINITIATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/FORMER/NEVER	TRANSITION PROBABILITY	0.0402	RATIO / 10 PER 1000
13	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENTNEVER/NEVERFORMER	TOBACCO PRODUCT USE TRANSITION TYPE	SWITCHINGRELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMERNEVER/CURRENT	TRANSITION PROBABILITY	0.0302	RATIO / 10 PER 1000
14	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	NEVER/FORMER/NEVER	TOBACCO PRODUCT USE TRANSITION TYPE	INITIATIONRELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMERCURRENT/CURRENT	TRANSITION PROBABILITY	0.0502	RATIO / 10 PER 1000
15	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	NEVER/FORMERNEVER	TOBACCO PRODUCT USE TRANSITION TYPE	INITIATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/FORMERNEVER	TRANSITION PROBABILITY	0.0201	RATIO / 10 PER 1000
16	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENT/FORMERNEVER	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	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	CURRENT/NEVER/FORMER	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSECESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENTFORMER/CURRENTNEVER	TRANSITION PROBABILITY	0.0204	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/CURRENTNEVER	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/CURRENTNEVER	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	CURRENT FORMER/ FORMER NEVER	TOBACCO PRODUCT USE TRANSITION TYPE	CESSATIONINITIATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMER/FORMERCURRENT	TRANSITION PROBABILITY	0.0205	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	CESSATIONRELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMERCURRENT/FORMERCURRENT	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	SWITCHINGCESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENTFORMER/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	CURRENTFORMER/FORMER	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSE	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENTFORMER/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	FORMERCURRENT/FORMERNEVER	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSEINITIATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMERCURRENT/CURRENT	TRANSITION PROBABILITY	0.0201	RATIO / 10 PER 1000
25	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	FORMERCURRENT/FORMERCURRENT	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSECESSATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	FORMER/CURRENT/FORMER	TRANSITION PROBABILITY	0.0201	RATIO / 10 PER 1000
26	YEAR	2000	AGE	24	SEX	F	TOBACCO PRODUCT CATEGORY	CIGARETTESCIGARETTE/CIGAR	TOBACCO PRODUCT USE STATUS PRE-TRANSITION	FORMERNEVER/NEVERCURRENT	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSEINITIATION	TOBACCO PRODUCT USE STATUS POST-TRANSITION	CURRENT/NEVERCURRENT	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	NEVERFORMER/FORMERCURRENT	TOBACCO PRODUCT USE TRANSITION TYPE	RELAPSESWITCHING	TOBACCO PRODUCT USE STATUS POST-TRANSITION	NEVERCURRENT/CURRENTFORMER	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

OF INTEREST

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

INITIAL STATUS

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;

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

INITIATE

INITIATION;

INITIATE2

CESSATION;

CESSATION

SWITCHING;RELAPSE

;SWITCHING

	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

CIGARETTES;CIGARETTES/CIGAR;CIGAR

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

Page tree

Versions Compared

Old Version 55

New Version Current

Key