This is an example of an ADaM dataset designed to capture the reference data describing historical transitional probabilities.

In the example 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 probabilities. 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-4 then follow the different probabilities of transitions following pathway "e" to "p" to "e" (NEVER/NEVER to CURRENT/CURRENT to FORMER/FORMER). 

The rest of the rows show examples of various combinations and pathways of transitional probabilities that are captured in the historical data.

Row

STRTM1

STRVAL1

STRTM2

STRVAL2

STRTM3

STRVAL3

STRTM4STRVAL4STRTM5STRVAL5STRTM6STRVAL6STRTM7STRVAL7INPRMINPRMVALINPRMU

1

YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPEINITIATIONPRODUCTCIGARETTES/CIGARTRANSITION PROBABILITY0.15RATIO / 10 PER 1000
2YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPECESSATIONPRODUCTCIGARETTES/CIGARTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
3YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPERELAPSEPRODUCTCIGARETTES/CIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
4YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUS

NEVER/NEVER

TRANSITION TYPEINITIATIONPRODUCTCIGARETTESTRANSITION PROBABILITY0.01RATIO / 10 PER 1000
5YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPEINITIATE2PRODUCTCIGARETTES/CIGARTRANSITION PROBABILITY0.01RATIO / 10 PER 1000
7YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPECESSATIONPRODUCTCIGARTRANSITION PROBABILITY0.01RATIO / 10 PER 1000
8YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPECESSATIONPRODUCTCIGARETTESTRANSITION PROBABILITY0.01RATIO / 10 PER 1000
9YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPEINITIATIONPRODUCTCIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
10YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPEINITIATION2PRODUCTCIGARETTES/CIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
11YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/NEVERTRANSITION TYPESWITCHINGPRODUCTCIGARETTESTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
13YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/CURRENTTRANSITION TYPECESSATIONPRODUCTCIGARTRANSITION PROBABILITY0.06RATIO / 10 PER 1000
14YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/CURRENTTRANSITION TYPEINITIATIONPRODUCTCIGARETTESTRANSITION PROBABILITY0.04RATIO / 10 PER 1000
15YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/CURRENTTRANSITION TYPECESSATIONPRODUCTCIGARETTESTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
16YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSNEVER/CURRENTTRANSITION TYPERELAPSEPRODUCTCIGARETTESTRANSITION PROBABILITY0.05RATIO / 10 PER 1000
18YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSCURRENT/NEVERTRANSITION TYPESWITCHINGPRODUCTCIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
19YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSCURRENT/NEVERTRANSITION TYPECESSATIONPRODUCTCIGARETTESTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
20YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSCURRENT/NEVERTRANSITION TYPEINITIATIONPRODUCTCIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
21YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSCURRENT/NEVERTRANSITION TYPECESSATIONPRODUCTCIGARTRANSITION PROBABILITY0.03RATIO / 10 PER 1000
22YEAR2000AGE60SEXFPRODUCT OF INTERESTCIGARETTES/CIGARINITIAL STATUSCURRENT/NEVERTRANSITION TYPERELAPSEPRODUCTCIGARTRANSITION PROBABILITY0.02RATIO / 10 PER 1000
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
RFTRANSPReference Data for Transition ProbREFERENCE DATA STRUCTUREone record per input valuereferenceSTRTM1, STRM2, STRTM3, STRTM4 STRTM5 STRTM6 STRTM7rftransp.xptNA
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 4textTRANSITION TYPECondpopulate 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

INITIAL;INITIATE;INITIATE2;QUIT;RELAPSE;SWITCH

Condpopulate with the STRTM4 values in the source data (Product in this example)
STRTM5Stratum 5textPRODUCTCondpopulate 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

textCIGARETTES;CIGARETTES/CIGAR;CIGAR;NEVER/NEVER;NEVER/CURRENT;CURRENT/NEVERCondpopulate with the STRTM5 values in the source data (Transition Type in this example)
STRTM6Stratum 6textINITIAL STATUSCondpopulate 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

textNEVER/NEVER;NEVER/CURRENT;CURRENT/NEVERCondpopulate with the STRTM6 values in the source data (Transition Type in this example)
STRTM7Stratum 7textPRODUCT OF INTERESTCondpopulate 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

textCIGARETTES/CIGARCondpopulate 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