ADaM Example.Initial Population

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	STRTM4	STRVAL4	STRTM5	STRVAL5	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	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	NEVER	PREVALENCE			70	PERCENT	initial population 2017.xlsx
8	AGE	10	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	NEVER	PREVALENCE			68	PERCENT	initial population 2017.xlsx
9	AGE	20	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	CURRENT	PREVALENCE			69	PERCENT	initial population 2017.xlsx
10	AGE	30	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	CURRENT	PREVALENCE			70	PERCENT	initial population 2017.xlsx
11	AGE	40	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	FORMER	PREVALENCE			72	PERCENT	initial population 2017.xlsx
12	AGE	50	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE	TOBACCO PRODUCT USE STATUS	FORMER	PREVALENCE			71	PERCENT	initial population 2017.xlsx
	AGE	0	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE/ENDS	TOBACCO PRODUCT USE STATUS	FORMER/CURRENT	PREVALENCE			<NEW EXAMPLE RECORD>	PERCENT	initial population 2017.xlsx
	AGE	10	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY	CIGARETTE/ENDS	TOBACCO PRODUCT USE STATUS	FORMER/CURRENT	PREVALENCE			<NEW EXAMPLE RECORD>	PERCENT	initial population 2017.xlsx

	AGE	0	SEX	M	RACE	WHITE	TOBACCO PRODUCT CATEGORY 1	CIGARETTE	TOBACCO PRODUCT USE STATUS	FORMER	TOBACCO PRODUCT CATEGORY 2	ENDS	TOBACCO PRODUCT USE STATUS	CURRENT	PERCENT	VALUE




	AGE	20	SEX	M	RACE	WHITE										initial population 2017.xlsx
	AGE	30	SEX	M	RACE	WHITE										initial population 2017.xlsx
	AGE	40	SEX	M	RACE	WHITE										initial population 2017.xlsx
	AGE	50	SEX	M	RACE	WHITE										initial population 2017.xlsx

Dataset Debug Message

There seem to be some variable names missing in the heading row.

RFIP Dataset Metadata

Dataset	Description	Class	Structure	Purpose	Keys	Location	Documentation
RFIP	Reference Data for Initial Population)	REFERENCE DATA STRUCTURE	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)

Page tree

ADaM Example.Initial Population