You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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.

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.

lb.xpt

lb.xpt

RowSTUDYIDDOMAINUSUBJIDLBSEQLBTESTCDLBTESTLBCATLBORRESLBORRESULBSTRESCLBSTRESNLBSTRESULBSTNRCLBSPECLBMETHODLBBLFLLBDTCLBDYLBNOMDY
1ABCLBABC-001-0011KETONESKetonesURINALYSISSMALL SMALL  NEGATIVE TO LARGEURINE  2006-07-1911
2ABCLBABC-001-0022KETONESKetonesURINALYSISLARGE LARGE  NEGATIVE TO LARGEURINE  2006-07-1911
3ABCLBABC-001-0013BILIBilirubinURINALYSISNEGATIVE NEGATIVE  NEGATIVE TO 3+URINE  2006-07-1911
4ABCLBABC-001-0024BILIBilirubinURINALYSIS2+ 2+  NEGATIVE TO 3+URINE  2006-07-1911
5ABCLBABC-001-0015PROTProteinURINALYSISTRACE TRACE  NEGATIVE TO 100URINE  2006-07-1911
6ABCLBABC-001-0026PROTProteinURINALYSIS30 30  NEGATIVE TO 100URINE  2006-07-1911
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

  • No labels