| Option 1 of Steve H's suggestion of combining our previous product identifiers and product descriptors into a single dataset:
| Rowcaps |
|---|
| Rows 1-4: | Show the records for a tobacco product given SPTOBID of CIG01a. | | Rows 3-4: | Show the tobacco product is a filtered, combusted type of cigarette. | |
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | TOSEQ | TOPARMCD | TOPARM | TOVAL | TOVALU |
|---|
| 1 | TOB07 | TO | CIG01a | 1 | TBPRDCAT | Tobacco Product Category | Cigarette |
| | 2 | TOB07 | TO | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory | Filtered, Combusted |
| | 3 | TOB07 | TO | CIG01a | 3 | MANUF | Manufacturer | Joes Cigs USA |
| | 4 | TOB07 | TO | CIG01a | 4 | TRADENAM | Trade Name | Treetop Menthol King Size |
| | 5 | TOB07 | TO | CIG01a | 5 | PACKTYP | Package Type | HARD PACK |
| | 6 | TOB07 | TO | CIG01a | 6 | PRDQUAN | Product Quantity | 20 | CIGARETTE | | 7 | TOB07 | TO | CIG01a | 7 | LENGTH | Length | 86.0 | mm | | 8 | TOB07 | TO | CIG01a | 8 | CIRCUMF | Circumference | 26.0 | mm | | 9 | TOB07 | TO | CIG01a | 9 | VENTLTN | Ventilation | 10.0 | % | | 10 | TOB07 | TO | CIG01a | 10 | CHARFLAV | Characterizing Flavor | MENTHOL |
|
|
Option 2 of Steve H's suggestion of combining our previous product identifiers and product descriptors into a single dataset:
| Dataset2 |
|---|
| Row | STUDYID | DOMAIN | SPTOBID | DPSEQTOSEQ | DPTESTCDTOTESTCD | DPTESTTOTEST | DPCATTOCAT | DPSCATTOSCAT | DPORRESTOORRES | DPORRESUTOORRESU | DPSTRESCTOSTRESC | DPSTRESNTOSTRESN | DPSTRESUTOSTRESU | DPCOLSRTTOCOLSRT |
|---|
| 1 | TOB07 | DPTO | CIG01a | | TBPRDCAT | Tobacco Product Category |
|
| Cigarette |
| Cigarette |
|
|
| | 2 | TOB07 | DPTO | CIG01a | 2 | TBPRSCAT | Tobacco Product Subcategory |
|
| Filtered, Combusted |
| Filtered, Combusted |
|
|
| | 3 | TOB07 | DPTO | CIG01a | 3 | MANUF | Manufacturer |
|
| Joes Cigs USA |
| Joes Cigs USA |
|
|
| | 4 | TOB07 | DPTO | CIG01a | 4 | TRADENAM | Trade Name |
|
| Treetop Methol King Size |
| Treetop Methol King Size |
|
|
| | 5 | TOB07 | DPTO | CIG01a | 5 | PACKTYP | Package Type |
|
| HARD PACK |
| HARD PACK |
|
|
| | 6 | TOB07 | DPTO | CIG01a | 6 | PRDQUAN | Product Quantity |
|
| 20 | CIGARETTE | 20 | 20 | CIGARETTE |
| | 7 | TOB07 | DPTO | CIG01a | 7 | LENGTH | Length |
|
| 86.0 | mm | 86.0 | 86.0 | mm |
| | 8 | TOB07 | DPTO | CIG01a | 8 | CIRCUMF | Circumference |
|
| 26.0 | mm | 26.0 | 26.0 | mm |
| | 9 | TOB07 | DPTO | CIG01a | 9 | VENTLTN | Ventilation |
|
| 10.0 | % | 10.0 | 10.0 | % |
| | 10 | TOB07 | DPTO | CIG01a | 10 | CHARFLAV | Characterizing Flavor |
|
| MENTHOL |
| MENTHOL |
|
|
| | 11 | TOB07 | DPTO | CIG01a | 11 | HTSOURCE | Heat Source |
|
| xxx |
| xxx |
|
|
|
|
|