| 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 |
|
|
...
| 2 animals. The test's values are categorical, using a list |
|
|
...
| (i.e., NEGATIVE, TRACE, SMALL, MODERATE, |
|
|
...
...
| ), the range of which is referenced in LBSTRNRC |
|
|
...
| . LBSTRESN is left null. | | Rows 3-4: | Show an example of urine bilirubin tests performed for |
|
|
...
| 2 animals. The test's values are categorical, using a list |
|
|
...
...
...
| represents 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 |
|
|
...
| 2 animals. The test's values are categorical, using a list |
|
|
...
| (i.e., NEGATIVE, TRACE, 30, |
|
|
...
| 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 |
|
|
...
...
...