Excerpt |
---|
The following example shows cases of categorical data that cannot be considered as numeric, even though in some cases it appears that the data includes a number. |
The allowed values in these ranges should be defined in the data definition file. Samples were collected at one point and not over a given interval.
Dataset wrap |
---|
|
Rowcaps |
---|
Rows 1-2: | Show an example of urine ketones tests performed for two animals. The test's values are categorical, using a list of NEGATIVE, TRACE, SMALL, MODERATE, and LARGE (the range of which is referenced in LBSTRNRC). LBSTRESN is left null. | Rows 3-4: | Show an example of urine bilirubin tests performed for two animals. The test's values are categorical, using a list of NEGATIVE, 1+, 2+, or 3+ which represent qualitative levels. Although the 1+, 2+, and 3+ values could be converted to numbers, the values represent a nonnumeric category based on an arbitrary scale; therefore, LBSTRESN is left blank. | Rows 5-6: | Show an example of urine protein tests performed for two animals. The test's values are categorical, using a list of NEGATIVE, TRACE, 30, and 100. Although the 30 and 100 values could be converted as numbers, the values represent a nonnumeric label of the result; therefore, LBSTRESN is left blank. |
|
Dataset2 |
---|
Row | STUDYID | DOMAIN | USUBJID | LBSEQ | LBTESTCD | LBTEST | LBCAT | LBORRES | LBORRESU | LBSTRESC | LBSTRESN | LBSTRESU | LBSTNRC | LBSPEC | LBMETHOD | LBBLFL | LBDTC | LBDY | LBNOMDY |
---|
1 | ABC | LB | ABC-001-001 | 1 | KETONES | Ketones | URINALYSIS | SMALL |
|
|
...
...
...
...
|
| 2006-07-19 | 1 | 1 | 2 | ABC | LB | ABC-001-002 | 2 | KETONES | Ketones | URINALYSIS | LARGE |
|
|
...
...
...
|
|
| 2006-07-19 | 1 | 1 | 3 | ABC | LB | ABC-001-001 | 3 | BILI | Bilirubin | URINALYSIS | NEGATIVE |
|
|
...
...
...
|
|
| 2006-07-19 | 1 | 1 | 4 | ABC | LB | ABC-001-002 | 4 | BILI | Bilirubin | URINALYSIS | 2+ |
|
|
...
...
...
...
|
| 2006-07-19 | 1 | 1 | 5 | ABC | LB | ABC-001-001 | 5 | PROT | Protein | URINALYSIS | TRACE |
|
|
...
...
...
|
|
| 2006-07-19 | 1 | 1 | 6 | ABC | LB | ABC-001-002 | 6 | PROT | Protein | URINALYSIS | 30 |
|
|
...
...
...