76 CELLPROP= LIBNAME Option Chapter 9
Syntax
CAST_OVERHEAD_MAXPERCENT=<n>
Syntax Description
<n>
Any positive numeric value. The engine default is 20.
Details
Teradata INTEGER, BYTEINT, SMALLINT, and DATE columns require conversion
when read in to SAS. Conversions can be performed either by Teradata or by SAS.
When performed in Teradata, using Teradata’s CAST operator, the row size transmitted
to SAS can increase. CAST_OVERHEAD_MAXPERCENT= limits the allowable
increase, also called conversion overhead.
Examples
The following example demonstrates the use of CAST_OVERHEAD_MAXPERCENT=
to increase the allowable overhead to 40 percent:
proc print data=mydblib.emp (CAST_OVERHEAD_MAXPERCENT=40);
where empno<1000;
run;
See Also
“CAST= LIBNAME Option” on page 74 for more information about conversions,
conversion overhead, and casting.
CELLPROP= LIBNAME Option
Modifies the metadata and content of a result data set that is defined through an MDX command
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: OLE DB
Default value:
VALUE
Syntax
CELLPROP=VALUE | FORMATTED_VALUE
Syntax Description
