Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Dataset wrap
Dataset2

Row

STRTM1

STRVAL1

STRTM2

STRVAL2STRTM3STRVAL3INPRMINPRMVALINPRMUREFSRCE
1YEAR2000SEXFRACETOTALBIRTH RATE

0.048156602

RATIO / 10 PER 1000

birthrate 2015.xslx

2YEAR

2001

SEXFRACETOTALBIRTH RATE0.050162384RATIO / 10 PER 1000birthrate 2015.xslx
3YEAR2002SEXFRACETOTALBIRTH RATE0.049912072RATIO / 10 PER 1000birthrate 2015.xslx
4YEAR2003SEXFRACETOTALBIRTH RATE0.049953214RATIO / 10 PER 1000birthrate 2015.xslx
5YEAR2004SEXFRACETOTALBIRTH RATE0.050199534RATIO / 10 PER 1000birthrate 2015.xslx
6YEAR2005

SEX

M

RACETOTALBIRTH RATE0.050497803RATIO / 10 PER 1000birthrate 2015.xslx
7YEAR

2001

SEXMRACETOTALBIRTH RATE0.052554053RATIO / 10 PER 1000birthrate 2015.xslx
8YEAR2002SEXMRACETOTALBIRTH RATE0.052289152RATIO / 10 PER 1000birthrate 2015.xslx
9YEAR2003SEXMRACETOTALBIRTH RATE0.052334712RATIO / 10 PER 1000birthrate 2015.xslx
10YEAR2004SEXMRACETOTALBIRTH RATE0.052594772RATIO / 10 PER 1000birthrate 2015.xslx
11YEAR2000SEXFRACEWHITEBIRTH RATE0.043829866RATIO / 10 PER 1000birthrate 2015.xslx
12YEAR

2001

SEXFRACEWHITEBIRTH RATE0.04509937RATIO / 10 PER 1000birthrate 2015.xslx
13YEAR2002SEXFRACEWHITEBIRTH RATE0.044711283RATIO / 10 PER 1000birthrate 2015.xslx
14YEAR2003SEXFRACEWHITEBIRTH RATE0.044899939RATIO / 10 PER 1000birthrate 2015.xslx
15YEAR2004SEXFRACEWHITEBIRTH RATE0.045284915RATIO / 10 PER 1000birthrate 2015.xslx
Definexmltable
LevelDataset
PurposeAnalysis
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
RFBRReference Data for BirthrateREFERENCE DATA STRUCTUREone record per input valuereferenceSTRTM1, STRM2, STRTM3rfbr.xptN/A
Definexmltable
LevelVariable
PurposeAnalysis
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum 1textYEARReqpopulate 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 Valuetext
Reqpopulate with the STRTM1 values in the source data (years 2000-2050 in this example)
STRTM2Stratum 2

text

SEXCondpopulate 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 ValuetextM;FCondpopulate with the STRTM2 values in the source data (M/F in this example for displayed data)
STRTM3Stratum 3textRACECondpopulate 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 ValuetextTOTAL;WHITECondpopulate with the STRTM3 values in the source data (Race in this example)
INPRMInput ParametertextBIRTH RATEReqpopulate 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
INPRMVALInput Parameter Valuefloat
Reqpopulate with the cell value from the referenced data that is being described by the STRMVALy values
INPRMUInput Parameter Unittext

RATIO / 10 PER 1000

Permpopulate with the unit describing the cell values if appropriate
REFSRCEReference Data Sourcetext


Permpopulate 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)