...
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 any combination of factors used to describe reference values (e.g., year in the birth rate spreadsheet) or by parsing the column identifiers to capture unique stratum data); sometimes these factors may be defined as compound factors (e.g., sex_race as sex and race in the birth rate spreadsheetsource data). The y index for STRTMy does not indicate any particular ordering - ; the y value merely indicates a unique identifierfactor. if If STRTMy concepts change across the row or column identifiers the source data, the same STRTMy variable is still used (ie.eg., in the metadata source data if column 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 that combinations of levels of granularity will be consistent across rows or columns - if the source reference data. If that is not the case, then some of the STRTMy/STRMVALy variables may be null.
...
...
...
...
...
text
...
...
...
...
...
...
question - ??? case for STRTMy?? use SDTM variables/CT if relevant??
...
...
...
| Dataset2 |
|---|
| | | STRVAL1 | | STRVAL2 | STRTM3 | STRVAL3 | INPRM | INPRMVAL | INPRMU | REFSRCE |
|---|
| 1 | YEAR | 2000 | SEX | F | RACE | TOTAL |
|
|
...
...
...
...
...
| TOTAL | BIRTH RATE | 0.050162384 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 3 | YEAR | 2002 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.049912072 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 4 | YEAR | 2003 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.049953214 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 5 | YEAR | 2004 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.050199534 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 6 | YEAR | 2005 | SEX |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.050497803 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 7 | YEAR | 2001 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.052554053 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 8 | YEAR | 2002 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.052289152 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 9 | YEAR | 2003 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.052334712 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 10 | YEAR | 2004 |
|
|
...
...
...
| TOTAL | BIRTH RATE | 0.052594772 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 11 | YEAR | 2000 |
|
|
...
...
...
| WHITE | BIRTH RATE | 0.043829866 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 12 | YEAR | 2001 |
|
|
...
...
...
| WHITE | BIRTH RATE | 0.04509937 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 13 | YEAR | 2002 |
|
|
...
...
...
| WHITE | BIRTH RATE | 0.044711283 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 14 | YEAR | 2003 |
|
|
...
...
...
| WHITE | BIRTH RATE | 0.044899939 | RATIO / 10 PER 1000 |
|
|
...
| birthrate 2015.xslx | | 15 | YEAR | 2004 |
|
|
...
...
...
| WHITE | BIRTH RATE | 0.045284915 | RATIO / 10 PER 1000 |
|
|
...
| Definexmltable |
|---|
| Level | Dataset |
|---|
| Purpose | Analysis |
|---|
|
| Dataset | Description | Class | Structure | Purpose | Keys | Location | Documentation |
|---|
| RFBR | Reference Data for Birthrate | REFERENCE DATA STRUCTURE | one record per input value | reference | STRTM1, STRM2, STRTM3 | rfbr.xpt | N/A | |
| Definexmltable |
|---|
| Dataset | RFBR |
|---|
| Level | Variable |
|---|
| Name | RFBR |
|---|
|
| Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Notes |
|---|
| STRTM1 | Stratum 1 | text | YEAR | Req | populate 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 | | Stratum 1 Value | text |
| Req | populate with the STRTM1 values in the source data (years 2000-2050 in this example) | | STRTM2 | Stratum 2 | text | SEX | Cond | populate 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 | | Stratum 2 Value | text | M;F | Cond | populate with the STRTM2 values in the source data (M/F in this example for displayed data) | | STRTM3 | Stratum 3 | text | RACE | Cond | populate 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 | | Stratum 3 Value | text | TOTAL;WHITE | Cond | populate with the STRTM3 values in the source data (Race in this example) | | INPRM | Input Parameter | text | BIRTH RATE | Req | populate 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 | | INPRMVAL | Input Parameter Value | float |
| Req | populate with the cell value from the referenced data that is being described by the STRMVALy values | | INPRMU | Input Parameter Unit | text | | Perm | populate with the unit describing the cell values if appropriate | | REFSRCE | Reference Data Source | text | | Perm | populate 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) |
|