Page History

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

Name	lb

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, 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 2 animals. The test's values are categorical, using a list (i.e., NEGATIVE, 1+, 2+, 3+) which 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	LBSTRESC	LBSTNRC	LBSPEC	LBDTC	LBDY	LBNOMDY
1	ABC	LB	ABC-001-001	1	KETONES	Ketones	URINALYSIS	SMALL	SMALL	NEGATIVE TO LARGE	URINE	2006-07-19	1	1
2	ABC	LB	ABC-001-002	2	KETONES	Ketones	URINALYSIS	LARGE	LARGE	NEGATIVE TO LARGE	URINE	2006-07-19	1	1
3	ABC	LB	ABC-001-001	3	BILI	Bilirubin	URINALYSIS	NEGATIVE	NEGATIVE	NEGATIVE TO 3+	URINE	2006-07-19	1	1
4	ABC	LB	ABC-001-002	4	BILI	Bilirubin	URINALYSIS	2+	2+	NEGATIVE TO 3+	URINE	2006-07-19	1	1
5	ABC	LB	ABC-001-001	5	PROT	Protein	URINALYSIS	TRACE	TRACE	NEGATIVE TO 100	URINE	2006-07-19	1	1
6	ABC	LB	ABC-001-002	6	PROT	Protein	URINALYSIS	30	30	NEGATIVE TO 100	URINE	2006-07-19	1	1

Page tree