ADaM Example.Birth Rate

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

STRTMy captures the different stratum variables describing the content of a particular cell in the dataset. Stratum may be based on any combination of factors used to describe reference values (e.g. year in the birth rate data) and sometimes these factors may be defined as compound factors (e.g. sex_race as sex and race in the birth rate source data). The y index for STRTMy does not indicate any particular ordering - the y value merely indicates a unique factor. If STRTMy concepts change across source data, the same STRTMy variable is still used (i.e. in the source data if a stratum changes from SEX to ETHNIC as the second stratum, then the same STRTM2 variable would be used and the value would change from Sex to Ethnic). The general assumption is the combinations of levels of granularity will be consistent across the source reference data - if that is not the case then some of the STRTMy/STRMVALy variables may be null.

$titleHtml

xx.xpt

Row	STRTM1	STRVAL1	STRTM2	STRVAL2	STRTM3	STRVAL3	INPRM	INPRMVAL	INPRMU	REFSRCE
1	YEAR	2000	SEX	F	RACE	TOTAL	BIRTH RATE	0.048156602	RATIO / 10 PER 1000	birthrate 2015.xslx
2	YEAR	2001	SEX	F	RACE	TOTAL	BIRTH RATE	0.050162384	RATIO / 10 PER 1000	birthrate 2015.xslx
3	YEAR	2002	SEX	F	RACE	TOTAL	BIRTH RATE	0.049912072	RATIO / 10 PER 1000	birthrate 2015.xslx
4	YEAR	2003	SEX	F	RACE	TOTAL	BIRTH RATE	0.049953214	RATIO / 10 PER 1000	birthrate 2015.xslx
5	YEAR	2004	SEX	F	RACE	TOTAL	BIRTH RATE	0.050199534	RATIO / 10 PER 1000	birthrate 2015.xslx
6	YEAR	2005	SEX	M	RACE	TOTAL	BIRTH RATE	0.050497803	RATIO / 10 PER 1000	birthrate 2015.xslx
7	YEAR	2001	SEX	M	RACE	TOTAL	BIRTH RATE	0.052554053	RATIO / 10 PER 1000	birthrate 2015.xslx
8	YEAR	2002	SEX	M	RACE	TOTAL	BIRTH RATE	0.052289152	RATIO / 10 PER 1000	birthrate 2015.xslx
9	YEAR	2003	SEX	M	RACE	TOTAL	BIRTH RATE	0.052334712	RATIO / 10 PER 1000	birthrate 2015.xslx
10	YEAR	2004	SEX	M	RACE	TOTAL	BIRTH RATE	0.052594772	RATIO / 10 PER 1000	birthrate 2015.xslx
11	YEAR	2000	SEX	F	RACE	WHITE	BIRTH RATE	0.043829866	RATIO / 10 PER 1000	birthrate 2015.xslx
12	YEAR	2001	SEX	F	RACE	WHITE	BIRTH RATE	0.04509937	RATIO / 10 PER 1000	birthrate 2015.xslx
13	YEAR	2002	SEX	F	RACE	WHITE	BIRTH RATE	0.044711283	RATIO / 10 PER 1000	birthrate 2015.xslx
14	YEAR	2003	SEX	F	RACE	WHITE	BIRTH RATE	0.044899939	RATIO / 10 PER 1000	birthrate 2015.xslx
15	YEAR	2004	SEX	F	RACE	WHITE	BIRTH RATE	0.045284915	RATIO / 10 PER 1000	birthrate 2015.xslx

$warningHtml

Dataset Metadata

Dataset	Description	Class	Structure	Purpose	Keys	Location	Documentation

ADXX Variable Metadata

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 (years 2000-2050 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	Cond	populate with the STRTM2 values in the source data (M/F 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;WHITE	Cond	populate with the STRTM3 values in the source data (Race in this example)
INPRM	Input Parameter	text	BIRTH 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	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
REFSRCE	Reference Data Source	text		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)

Page tree

ADaM Example.Birth Rate