Versions Compared

Old Version 54

changes.mady.by.user Christine Connolly

Saved on

compared with

New Version Current

changes.mady.by.user Alana St. Clair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
NameRFTRANSP
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.

...

RFTRANSP
Dataset wrap
Name
Dataset2
tableidrftransp.xpt

Row

STRTM1

STRVAL1

STRTM2

STRVAL2

STRTM3

STRVAL3

STRTM4STRVAL4STRTM5STRVAL5STRTM6STRVAL6STRTM7STRVAL7INPRMINPRMVALINPRMU

1

YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/NEVERTOBACCO PRODUCT USE TRANSITION TYPEINITIATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/CURRENTTRANSITION PROBABILITY0.15RATIO / 10 PER 1000
2YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/CURRENTTOBACCO PRODUCT USE TRANSITION TYPECESSATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/FORMERTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
3YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/FORMERTOBACCO PRODUCT USE TRANSITION TYPERELAPSE
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/CURRENTTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
4YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/NEVERTOBACCO PRODUCT USE TRANSITION TYPEINITIATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONNEVER/CURRENT
CURRENT/NEVER
TRANSITION PROBABILITY0.
01
02RATIO / 10 PER 1000
5YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/CURRENT
CURRENT/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
INITIATION
SWITCHINGTOBACCO PRODUCT USE STATUS POST-TRANSITION
"CURRENT STATUS/AFTER TRANSITION"
CURRENT/
CURRENT
FORMERTRANSITION PROBABILITY0.
01
02RATIO / 10 PER 1000
6YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER
CURRENT
/CURRENTTOBACCO PRODUCT USE TRANSITION TYPECESSATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONNEVER/FORMER
FORMER/CURRENT
TRANSITION PROBABILITY0.
01
06RATIO / 10 PER 1000
7YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/
CURRENT
FORMERTOBACCO PRODUCT USE TRANSITION TYPE
CESSATION"CURRENT STATUS/AFTER TRANSITION"
SWITCHINGTOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/CURRENT
CURRENT/FORMER
TRANSITION PROBABILITY0.
01
03RATIO / 10 PER 1000
8YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/FORMER
NEVER/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
INITIATION"CURRENT STATUS/AFTER TRANSITION"
CESSATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/FORMER
NEVER/CURRENT
TRANSITION PROBABILITY0.02RATIO / 10 PER 1000
9YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/FORMER
NEVER/CURRENT
TOBACCO PRODUCT USE TRANSITION TYPE
INITIATION
RELAPSETOBACCO PRODUCT USE STATUS POST-TRANSITION
"CURRENT STATUS/AFTER TRANSITION"
CURRENT/
CURRENT
FORMERTRANSITION PROBABILITY0.02RATIO / 10 PER 1000

10

YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/FORMER
NEVER/CURRENT
TOBACCO PRODUCT USE TRANSITION TYPE
SWITCHING
RELAPSETOBACCO PRODUCT USE STATUS POST-TRANSITION
"CURRENT STATUS/AFTER TRANSITION"
CURRENT/
FORMER
CURRENTTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
11YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT
NEVER
/CURRENTTOBACCO PRODUCT USE TRANSITION TYPECESSATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT
NEVER
/FORMERTRANSITION PROBABILITY0.
06
01RATIO / 10 PER 1000
12YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/FORMER
CURRENT/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
CESSATION"CURRENT STATUS/AFTER TRANSITION"
INITIATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/FORMER
FORMER/NEVER
TRANSITION PROBABILITY0.
04
02RATIO / 10 PER 1000
13YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/FORMER
CURRENT/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
SWITCHING"CURRENT STATUS/AFTER TRANSITION"
RELAPSETOBACCO PRODUCT USE STATUS POST-TRANSITIONNEVER
FORMER
/CURRENTTRANSITION PROBABILITY0.
03
02RATIO / 10 PER 1000
14YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/FORMER
FORMER/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
INITIATION"CURRENT STATUS/AFTER TRANSITION"
RELAPSETOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT
FORMER
/CURRENTTRANSITION PROBABILITY0.
05
02RATIO / 10 PER 1000
15YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/
FORMER
NEVERTOBACCO PRODUCT USE TRANSITION TYPEINITIATION
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/
FORMER
NEVERTRANSITION PROBABILITY0.
02
01RATIO / 10 PER 1000
16YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/
FORMER
NEVERTOBACCO PRODUCT USE TRANSITION TYPESWITCHING
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/CURRENTTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
17YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/NEVER
NEVER/FORMER
TOBACCO PRODUCT USE TRANSITION TYPE
RELAPSE"CURRENT STATUS/AFTER TRANSITION"
CESSATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/NEVER
CURRENT/CURRENT
TRANSITION PROBABILITY0.
02
04RATIO / 10 PER 1000
18YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITION

FORMER/NEVER

TOBACCO PRODUCT USE TRANSITION TYPERELAPSE
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/CURRENTTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
19YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/
CURRENT
NEVERTOBACCO PRODUCT USE TRANSITION TYPERELAPSE
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/
CURRENT
NEVERTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
20YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITION

FORMER/NEVER

CURRENT/FORMER

TOBACCO PRODUCT USE TRANSITION TYPE
CESSATION
INITIATIONTOBACCO PRODUCT USE STATUS POST-TRANSITION
"CURRENT STATUS/AFTER TRANSITION"
FORMER/
FORMER
CURRENTTRANSITION PROBABILITY0.
02
05RATIO / 10 PER 1000
21YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/CURRENTTOBACCO PRODUCT USE TRANSITION TYPE
CESSATION"CURRENT STATUS/AFTER TRANSITION"
RELAPSETOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/CURRENT
FORMER/FORMER
TRANSITION PROBABILITY0.02RATIO / 10 PER 1000
22YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/CURRENTTOBACCO PRODUCT USE TRANSITION TYPE
SWITCHING"CURRENT STATUS/AFTER TRANSITION"
CESSATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER
CURRENT
/FORMERTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
23YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER
CURRENT
/FORMERTOBACCO PRODUCT USE TRANSITION TYPERELAPSE
"CURRENT STATUS/AFTER TRANSITION"
TOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER
CURRENT
/CURRENTTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
24YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/NEVER
FORMER/FORMER
TOBACCO PRODUCT USE TRANSITION TYPE
RELAPSE"CURRENT STATUS/AFTER TRANSITION"
INITIATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT
FORMER
/CURRENTTRANSITION PROBABILITY0.
02
01RATIO / 10 PER 1000
25YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONCURRENT/CURRENT
FORMER/FORMER
TOBACCO PRODUCT USE TRANSITION TYPE
RELAPSE"CURRENT STATUS/AFTER TRANSITION"
CESSATIONTOBACCO PRODUCT USE STATUS POST-TRANSITIONFORMER/CURRENT
CURRENT/FORMER
TRANSITION PROBABILITY0.
02
01RATIO / 10 PER 1000
26YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONNEVER/CURRENT
FORMER/NEVER
TOBACCO PRODUCT USE TRANSITION TYPE
RELAPSE
INITIATIONTOBACCO PRODUCT USE STATUS POST-TRANSITION
"CURRENT STATUS/AFTER TRANSITION"
CURRENT/
NEVER
CURRENTTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
27YEAR2000AGE24SEXFTOBACCO PRODUCT CATEGORY
CIGARETTES
CIGARETTE/CIGAR
"CURRENT STATUS/BEFORE TRANSITION"
TOBACCO PRODUCT USE STATUS PRE-TRANSITIONFORMER/CURRENT
NEVER/FORMER
TOBACCO PRODUCT USE TRANSITION TYPE
RELAPSE"CURRENT STATUS/AFTER TRANSITION"
SWITCHINGTOBACCO PRODUCT USE STATUS POST-TRANSITIONCURRENT/FORMER
NEVER/CURRENT
TRANSITION PROBABILITY0.02RATIO / 10 PER 1000
Definexmltable
LevelDataset
PurposeAnalysis
OIDRFTRANSP
NameRFTRANSP
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
RFTRANSPReference Data for Transition ProbREFERENCE DATA STRUCTUREone record per input valuereferenceSTRTM1, STRM2, STRTM3, STRTM4 STRTM5 STRTM6 STRTM7rftransp.xptNA
Definexmltable
DatasetRFTRANSPCustomtrue
LevelVariable
NameRFTRANSP
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textYEARReqpopulate 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
Reqpopulate with the STRTM1 values in the source data (Age in this example)
STRTM2Stratum 2

text

AGECondpopulate 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
Condpopulate with the STRTM2 values in the source data (F in this example for displayed data)
STRTM3Stratum 3textSEXCondpopulate 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

textFCondpopulate with the STRTM3 values in the source data (Transition Type in this example)
STRTM4Stratum 4text

TOBACCO PRODUCT

OF INTEREST

CATEGORY

Condpopulate 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

Condpopulate with the STRTM4 values in the source data (Product in this example)
STRTM5Stratum 5text
INITIAL STATUS

TOBACCO PRODUCT USE STATUS PRE-TRANSITION

Condpopulate 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;

CURRENT

NEVER/NEVER

Condpopulate with the STRTM5 values in the source data (Transition Type in this example)
STRTM6Stratum 6textTOBACCO PRODUCT USE TRANSITION TYPECondpopulate 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
Condpopulate with the STRTM6 values in the source data (Transition Type in this example)
STRTM7Stratum 7textTOBACCO PRODUCT USE STATUS POST-TRANSITIONCondpopulate 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


Condpopulate with the STRTM7 values in the source data (Transition Type in this example)
INPRMInput ParametertextTRANSITION PROBABILITYReqpopulate 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
INPRMVALInput Parameter Valuefloat
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMUInput Parameter UnittextRATIO / 10 PER 1000Permpopulate with the unit describing the cell values if appropriate