Page History

...

Dataset wrap

Dataset2

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

Definexmltable

Level	Dataset
Purpose	Analysis

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

Definexmltable

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

Versions Compared

Old Version 23

New Version 24

Key