Hi All,
We have sql pass-through code as below and get data using ODBC connection. can some help and suggest how to use with on pre-assigned libraries.
proc sql; connect to odbc as mydb (datasrc=dwprdsvc user=xxxxxxxxxxxx password=xxxxxxxxxxxxxxxxx); create table Var_tmp as select * from connection to mydb ( SET QUOTED_IDENTIFIER OFF execute executeoraclequery @query = %bquote(") /* all the latest scenario forecasts */ with LATEST as ( select query... ),
DATA as ( select query... ),
now i have pre-assigned library and i'm not able to convert it to required format...
when i converted as below
proc sql;
create table Oxford_Eco_Var_tmp as select * from (
with LATEST as (
select query...
),
DATA as ( select query... ),
i'm getting error as below.
proc sql;
27 create table Var_tmp as select * from (
28 with LATEST as (
__
22
201
ERROR 22-322: Syntax error, expecting one of the following: ',', ANSIMISS, CROSS, FULL, INNER, JOIN, LEFT, NATURAL, NOMISS, RIGHT.
ERROR 201-322: The option is not recognized and will be ignored.
Please suggest and let me know.
Thanks in advance.
... View more