CAST_OVERHEAD_MAXPERCENT= Data Set Option

Specifies the overhead limit for data conversions to perform in Teradata instead of SAS.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	20
Data source:	Teradata
See:	CAST= LIBNAME option, CAST= data set option, CAST_OVERHEAD_MAXPERCENT= LIBNAME option

Syntax

Details

Example

Syntax

CAST_OVERHEAD_MAXPERCENT=<n>

Syntax Description

<n>: specifies any positive numeric value. The engine default is 20.

Details

Teradata INTEGER, BYTEINT, SMALLINT, and DATE columns require conversion when read in to SAS. Either Teradata or SAS can perform conversions. When Teradata performs the conversion, the row size that is transmitted to SAS using the Teradata CAST operator can increase. CAST_OVERHEAD_MAXPERCENT= limits the allowable increase, also called conversion overhead.

For more information about conversions, conversion overhead, and casting, see the CAST= LIBNAME option.

Example: Increase the Allowable Overhead

This example demonstrates the use of CAST_OVERHEAD_MAXPERCENT= to increase the allowable overhead to 40%.

proc print data=mydblib.emp (cast_overhead_maxpercent=40);
where empno<1000;
run;