This is an example of an ADaM dataset designed to capture the reference data describing historical migration rates.
$titleHtml
xx.xpt
Row
STRTM1
STRVAL1
STRTM2
STRVAL2
STRTM3
STRVAL3
INPRM
INPRMVAL
INPRMU
1
YEAR
2001
SEX
F
RACE
TOTAL
MIGRATION RATE
100
COUNT
2
YEAR
2002
SEX
F
RACE
TOTAL
MIGRATION RATE
100
COUNT
3
YEAR
2003
SEX
F
RACE
TOTAL
MIGRATION RATE
100
COUNT
4
YEAR
2004
SEX
F
RACE
TOTAL
MIGRATION RATE
100
COUNT
5
YEAR
2005
SEX
F
RACE
TOTAL
MIGRATION RATE
100
COUNT
6
YEAR
2001
SEX
M
RACE
TOTAL
MIGRATION RATE
100
COUNT
7
YEAR
2002
SEX
M
RACE
TOTAL
MIGRATION RATE
100
COUNT
8
YEAR
2003
SEX
M
RACE
TOTAL
MIGRATION RATE
100
COUNT
9
YEAR
2004
SEX
M
RACE
TOTAL
MIGRATION RATE
100
COUNT
10
YEAR
2005
SEX
M
RACE
TOTAL
MIGRATION RATE
100
COUNT
11
YEAR
2001
SEX
TOTAL
RACE
TOTAL
MIGRATION RATE
100
COUNT
12
YEAR
2002
SEX
TOTAL
RACE
TOTAL
MIGRATION RATE
100
COUNT
13
YEAR
2003
SEX
TOTAL
RACE
TOTAL
MIGRATION RATE
100
COUNT
14
YEAR
2004
SEX
TOTAL
RACE
TOTAL
MIGRATION RATE
100
COUNT
15
YEAR
2005
SEX
TOTAL
RACE
TOTAL
MIGRATION RATE
100
COUNT
$warningHtml
RFMIGRAT Dataset Metadata
Dataset
Description
Class
Structure
Purpose
Keys
Location
Documentation
RFMIGRAT
Reference Data for Migration Rates
REFERENCE DATA STRUCTURE
one record per input value
reference
STRTM1, STRM2, STRTM3
rfmigrat.xpt
NA
ADXX 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
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 first part of the second column concept in this example
STRVAL2
Stratum 2 Value
text
M;F;Total
Cond
populate with the STRTM2 values in the source data (F/M/Total in this example for displayed data)
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 second part of the second column concept in this example
STRVAL3
Stratum 3 Value
text
Total
Cond
populate with the STRTM3 values in the source data (Race in this example)
INPRM
Input Parameter
text
MIGRATION RATE
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
integer
Req
populate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMU
Input Parameter Unit
text
COUNT
Perm
populate with the unit describing the cell values if appropriate