...
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) and 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 (i.e. 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 the 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 |
|---|
|
| Dataset2 |
|---|
| | STRVAL1 | | STRVAL2 | STRTM3 | STRVAL3 | INPRM | INPRMVAL | INPRMU | REFSRCE |
|---|
| 1 | YEAR | 2000 | SEX | F | RACE | TOTAL | BIRTH RATE | | | | | 2 | YEAR | 2001 | SEX | F | RACE | TOTAL | BIRTH RATE | 0.050162384 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 3 | YEAR | 2002 | SEX | F | RACE | TOTAL | BIRTH RATE | 0.049912072 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 4 | YEAR | 2003 | SEX | F | RACE | TOTAL | BIRTH RATE | 0.049953214 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 5 | YEAR | 2004 | SEX | F | RACE | TOTAL | BIRTH RATE | 0.050199534 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 6 | YEAR | 2005 | SEX | M | RACE | TOTAL | BIRTH RATE | 0.050497803 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 7 | YEAR | 2001 | SEX | M | RACE | TOTAL | BIRTH RATE | 0.052554053 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 8 | YEAR | 2002 | SEX | M | RACE | TOTAL | BIRTH RATE | 0.052289152 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 9 | YEAR | 2003 | SEX | M | RACE | TOTAL | BIRTH RATE | 0.052334712 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 10 | YEAR | 2004 | SEX | M | RACE | TOTAL | BIRTH RATE | 0.052594772 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 11 | YEAR | 2000 | SEX | F | RACE | WHITE | BIRTH RATE | 0.043829866 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 12 | YEAR | 2001 | SEX | F | RACE | WHITE | BIRTH RATE | 0.04509937 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 13 | YEAR | 2002 | SEX | F | RACE | WHITE | BIRTH RATE | 0.044711283 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 14 | YEAR | 2003 | SEX | F | RACE | WHITE | BIRTH RATE | 0.044899939 | RATIO / 10 PER 1000 | birthrate 2015.xslx | | 15 | YEAR | 2004 | SEX | F | RACE | WHITE | BIRTH RATE | 0.045284915 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
|
|
...