You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

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 column names of row identifiers (e.g. year in the birth rate spreadsheet) or by parsing the column identifiers to capture unique stratum (e.g. sex_race as sex and race in the birth rate spreadsheet). The y index for STRTMy does not indicate any particular ordering - the y value merely indicates a unique identifier. if STRTMy concepts change across the row or column identifiers the same STRTMy variable is still used (i.e. in the metadata if column changes from SEX to ETHNIC 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 rows or columns - if that is not the case then some of the STRTMy/STRMVALy variables may be null.


Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes
STRTM1Stratum y ValuetextyearReqpopulate 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

STRMVAL1

Stratum y Value

integer??
Reqpopulate with the STRTM1 values in the source data (years 2000-2050 in this example)
STRTM2Stratum y Value

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

STRMVAL2

Stratum y Value

textM;FCondpopulate with the STRTM2 values in the source data (M/F in this example for displayed data)
STRTM3Stratum y Valuetext
Condpopulate 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

STRMVAL3

Stratum y Value

textTotal;WhiteCondpopulate with the STRTM1 values in the source data (years 2000-2050 in this example)
INPRMInput Parameter ValuetextBIRTH 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 Valuetext

RATIO / 10 PER 1000

Permpopulate with the unit describing the cell values if appropriate


question - ??? case for STRTMy?? use SDTM variables/CT if relevant??

STRTM1

STRMVAL1

STRTM2

STRMVAL2STRTM3STRMVAL3INPRMINPRMVALINPRMU
year2000SexFRaceTotalBIRTH RATE

0.048156602

RATIO / 10 PER 1000

year

2001

SexFRaceTotalBIRTH RATE0.050162384RATIO / 10 PER 1000
year2002SexFRaceTotalBIRTH RATE0.049912072RATIO / 10 PER 1000
year2003SexFRaceTotalBIRTH RATE0.049953214RATIO / 10 PER 1000
year2004SexFRaceTotalBIRTH RATE0.050199534RATIO / 10 PER 1000
year2000

Sex

M

RaceTotalBIRTH RATE0.050497803RATIO / 10 PER 1000
year

2001

SexMRaceTotalBIRTH RATE0.052554053RATIO / 10 PER 1000
year2002SexMRaceTotalBIRTH RATE0.052289152RATIO / 10 PER 1000
year2003SexMRaceTotalBIRTH RATE0.052334712RATIO / 10 PER 1000
year2004SexMRaceTotalBIRTH RATE0.052594772RATIO / 10 PER 1000
year2000SexFRaceWhiteBIRTH RATE0.043829866RATIO / 10 PER 1000
year

2001

SexFRaceWhiteBIRTH RATE0.04509937RATIO / 10 PER 1000
year2002SexFRaceWhiteBIRTH RATE0.044711283RATIO / 10 PER 1000
year2003SexFRaceWhiteBIRTH RATE0.044899939RATIO / 10 PER 1000
year2004SexFRaceWhiteBIRTH RATE0.045284915RATIO / 10 PER 1000


The BRTHRATE.xpt dataset is created based on the data provided in the source reference spreadsheet BIRTHRATE.xls. the source spreadsheet  the spreadsheet contains 3 parameters that define the content of each birth rate value. The three parameters are year of birth (2000-2050), sex (male,female), and race (white, black, Asian, NHPI, etc). STRTM1/STRTM2/STRTM3 capture the concept being captured in the STRTMy variable and STRMVAL1/ STRMVAL2/STRMVAL3 capture the value within each STRTMy variable associated with each reference cell value. The concept being captured in the reference cell is captured in INPRM (BIRTH RATE in this example) and INPRMVAL captures the reference value provided in the source data. INPRMU is an additional variable that can be used to capture the unit associated with the reference data value.

  • No labels