This is an example of an ADaM dataset designed to capture the reference data describing the initial population.
$titleHtml
xx.xpt
Row
STRTM1
STRVAL1
STRTM2
STRVAL2
STRTM3
STRVAL3
INPRM
INPRMVAL
INPRMU
REFSRCE
1
AGE
0
SEX
M
RACE
WHITE
POPULATION COUNT
50
COUNT
initial population 2017.xlsx
2
AGE
10
SEX
M
RACE
WHITE
POPULATION COUNT
48
COUNT
initial population 2017.xlsx
3
AGE
20
SEX
M
RACE
WHITE
POPULATION COUNT
49
COUNT
initial population 2017.xlsx
4
AGE
30
SEX
M
RACE
WHITE
POPULATION COUNT
50
COUNT
initial population 2017.xlsx
5
AGE
40
SEX
M
RACE
WHITE
POPULATION COUNT
51
COUNT
initial population 2017.xlsx
6
AGE
50
SEX
M
RACE
WHITE
POPULATION COUNT
52
COUNT
initial population 2017.xlsx
7
AGE
0
SEX
M
RACE
WHITE
PREVALENCE
70
PERCENT
initial population 2017.xlsx
8
AGE
10
SEX
M
RACE
WHITE
PREVALENCE
68
PERCENT
initial population 2017.xlsx
9
AGE
20
SEX
M
RACE
WHITE
PREVALENCE
69
PERCENT
initial population 2017.xlsx
10
AGE
30
SEX
M
RACE
WHITE
PREVALENCE
70
PERCENT
initial population 2017.xlsx
11
AGE
40
SEX
M
RACE
WHITE
PREVALENCE
72
PERCENT
initial population 2017.xlsx
12
AGE
50
SEX
M
RACE
WHITE
PREVALENCE
71
PERCENT
initial population 2017.xlsx
$warningHtml
RFIP Dataset Metadata
Dataset
Description
Class
Structure
Purpose
Keys
Location
Documentation
RFIP
Reference Data for Initial Population)
REFERENCE
one record per input value
reference
STRTM1, STRM2, STRTM3
rfip.xpt
N/A
XX Variable Metadata
Variable Name
Variable Label
Type
Codelist/Controlled Terms
Core
Notes
STRTM1
Stratum 1
text
AGE
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
SEX
Cond
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the lower level of the fifth column in this example
STRVAL2
Stratum 2 Value
text
M;F
Cond
populate with the STRTM2 values in the source data (Sex in this example)
STRTM3
Stratum 3
text
Race
Cond
populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the upper level of the fifth column in this example
STRVAL3
Stratum 3 Value
text
White
Cond
populate with the STRTM3 values in the source data (Race in this example)
INPRM
Input Parameter
text
POPULATION COUNT;PREVALENCE
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 identifying 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
COUNT;PERCENT
Perm
populate with the unit describing the cell values if appropriate
REFSRCE
Reference Data Source
text
initial population 2017.xlsx
Perm
populate with the file that is the source of the reference data (the same columns and rows will change over time so identifying the source allows for traceability)