Your code has syntax errors. You are using the "Pass-Through" feature. "Format's" are exclusive features of SAS, they will not work inside the "Pass-Through" block. See "Pass-Through" In addition, oracle has no data type "date", only "date-time", but if your SAS is configured correctly, the SAS itself does the necessary conversions. Try this code: proc sql;
connect to ORACLE (user="xxxx" password="xxxx" buffsize=5000 path=test);
CREATE TABLE sample AS
SELECT
Acct_id,
datepart(DATE) as DT format date9.,
Num,
Name
FROM CONNECTION TO ORACLE
(
SELECT
ACCT.number as Acct_id, ACCT.DATE, ACCT.Num, Client.Name
FROM ACCT, Client
);
quit;
... View more