Data Set Options for Relational Databases |
Specifies the overhead limit for data conversions to perform in
Teradata instead of SAS.
Default value: |
20%
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Teradata
|
CAST_OVERHEAD_MAXPERCENT=<n>
|
-
<n>
-
Any positive numeric value. The engine default
is 20.
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.
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;
For more information about conversions, conversion overhead,
and casting, see the CAST= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.