Chapter Contents

DBSASTYPE=

DBSASTYPE=

Specifies data type(s) to override the default SAS data type(s) during input processing of data from ORACLE.

Default value: Varies by data type.

Syntax
Details

Syntax

DBSASTYPE=(<column-name-1=<'>SAS-data-type<'>> <...<column-name-n=<'SAS-data-type<'>>>)

column-name: specifies a DBMS column name.
SAS-data-type: specifies a SAS data type.

This option is valid only when you read ORACLE data into SAS.

By default, the SAS/ACCESS Interface to ORACLE converts each ORACLE data type to a predetermined SAS data type when processing data from ORACLE. When you need a different data type, you can use DBSASTYPE= to override the default data type chosen by the SAS/ACCESS engine.

In the following example, DBSASTYPE= specifies a data type to use for the column MYCOLUMN when printing the DBMS data in SAS. If the data in this DBMS column is stored in a format that SAS does not support, such as NUMBER(20), this enables SAS to print the values.

proc print data=mylib.mytable
   (DBSASTYPE=(mycolumn=$20.));
run;

See LIBNAME Statement Data Conversions for more details on the default data types for ORACLE.

Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.