Specifies a data type to use instead of the default DBMS data type when SAS creates a DBMS table.
Valid in: | DATA and PROC steps |
Default: | DBMS-specific |
Supports: | All |
specifies a DBMS data type. See the documentation for your data source for the default data types for your DBMS.
data mydblib.newdept(dbtype=(deptno='number(10,2)' city='char(25)')); set mydblib.dept; run;
data mydblib.newdept(dbtype=(deptno='byteint' city='char(25)')); set dept; run;
data mydblib.newemployees(dbtype= (empno="SMALLINT FORMAT '9(5)' CHECK (empno >= 100 AND empno <= 2000)")); set mydblib.employees; run;