Versions Compared

Key

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

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

...

parvar1

...

refvar1

...

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); 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 (e.g., 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 that 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.

Dataset wrap
Namerfbr
Dataset2
tableidRFBR

Row

STRTM1

STRVAL1

STRTM2

STRVAL2STRTM3STRVAL3INPRMINPRMVALINPRMUREFSRCE
1YEAR2000SEXFRACETOTAL

...

BIRTH RATE

0.048156602

RATIO / 10 PER 1000

...

birthrate 2015.xslx

2YEAR

...

2001

SEXFRACE

...

TOTALBIRTH RATE0.050162384RATIO / 10 PER 1000

...

birthrate 2015.xslx
3YEAR

...

2002SEXFRACE

...

TOTALBIRTH RATE0.049912072RATIO / 10 PER 1000birthrate 2015.xslx

...

4

...

YEAR2003SEXFRACE

...

TOTALBIRTH RATE0.049953214RATIO / 10 PER 1000birthrate 2015.xslx

...

5

...

YEAR2004SEXF

...

RACETOTALBIRTH RATE0.050199534RATIO / 10 PER 1000

...

birthrate 2015.xslx
6YEAR2005

SEX

...

M

...

RACETOTALBIRTH RATE0.050497803RATIO / 10 PER 1000

...

2

birthrate 2015.xslx
7YEAR

...

2001

SEXM

...

RACETOTALBIRTH RATE0.052554053RATIO / 10 PER 1000

...

birthrate 2015.xslx
8YEAR

...

2002SEXMRACE

...

TOTALBIRTH RATE0.052289152RATIO / 10 PER 1000birthrate 2015.xslx

...

9

...

YEAR2003SEXM

...

RACETOTALBIRTH RATE0.052334712RATIO / 10 PER 1000birthrate 2015.xslx

...

10

...

YEAR2004SEXM

...

RACETOTALBIRTH RATE0.052594772RATIO / 10 PER 1000birthrate 2015.xslx

...

11

...

YEAR2000SEXFRACE

...

WHITEBIRTH RATE0.043829866RATIO / 10 PER 1000birthrate 2015.xslx

...

12

...

YEAR

2001

SEXFRACE

...

WHITEBIRTH RATE0.04509937RATIO / 10 PER 1000

...

birthrate 2015.xslx
13YEAR

...

2002SEXFRACE

...

WHITEBIRTH RATE0.044711283RATIO / 10 PER 1000birthrate 2015.xslx

...

14

...

YEAR2003SEXFRACE

...

WHITEBIRTH RATE0.044899939RATIO / 10 PER 1000birthrate 2015.xslx

...

15

...

YEAR2004SEXF

...

RACEWHITEBIRTH 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
DatasetRFBR
LevelVariable
NameRFBR
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 identifying 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)