This is an example of an ADaM dataset designed to capture the reference data describing historical birth rates.
| STRMVAL1 | | STRMVAL2 | STRTM3 | STRMVAL3 | INPRM | INPRMVAL |
|---|
INPRMVAL | reford| INPRMU |
|---|
| year | 2000 | Sex | F | Race | Total | BIRTH RATE | | |
1 |
| year | 2001 | Sex | F | Race | Total | BIRTH RATE | 0.050162384 | RATIO / 10 PER 1000 |
1 |
| year | 2002 | Sex | F | Race | Total | BIRTH RATE | 0.049912072 | RATIO / 10 PER 1000 |
1 |
| year | 2003 | Sex | F | Race | Total | BIRTH RATE | 0.049953214 | RATIO / 10 PER 1000 |
1 |
| year | 2004 | Sex | F | Race | Total | BIRTH RATE | 0.050199534 | RATIO / 10 PER 1000 |
1 |
| year | 2000 | Sex | M | Race | Total | BIRTH RATE | 0.050497803 | RATIO / 10 PER 1000 |
2 |
| year | 2001 | Sex | M | Race | Total | BIRTH RATE | 0.052554053 | RATIO / 10 PER 1000 |
2 |
| year | 2002 | Sex | M | Race | Total | BIRTH RATE | 0.052289152 | RATIO / 10 PER 1000 |
2 |
| year | 2003 | Sex | M | Race | Total | BIRTH RATE | 0.052334712 | RATIO / 10 PER 1000 |
2 |
| year | 2004 | Sex | M | Race | Total | BIRTH RATE | 0.052594772 | RATIO / 10 PER 1000 |
2 |
| year | 2000 | Sex | F | Race | White | BIRTH RATE | 0.043829866 | RATIO / 10 PER 1000 |
3 |
| year | 2001 | Sex | F | Race | White | BIRTH RATE | 0.04509937 | RATIO / 10 PER 1000 |
3 |
| year | 2002 | Sex | F | Race | White | BIRTH RATE | 0.044711283 | RATIO / 10 PER 1000 |
3 |
| year | 2003 | Sex | F | Race | White | BIRTH RATE | 0.044899939 | RATIO / 10 PER 1000 |
3 |
| year | 2004 | Sex | F | Race | White | BIRTH RATE | 0.045284915 | RATIO / 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.