Hi Everyone. Let me preface this by saying that my SAS knowledge is around the medium level. I have around 60 queries that I need to have run at different scheduled times. I am having no issues with the batch submission. My problem is with calling the queries. I am using the following code:
x setenv ORACLE_SID PROD;
x setenv TWO_TASK PROD;
Proc sql;
connect to oracle as squery1 (user= orapw=);
create table BRPF_01 as
select *
from connection to squery1
( ***Insert***);
disconnect from squery1;
quit;
Ideally, what I would like is for this code to execute, but where it says ***Insert*** it would call the queries that I need to run. I was attempting to use %include, but I was unable to get that to run within the Proc SQL. Is there another way? Or a way to get it to call all the scripts within a certain folder?
Thanks!
x setenv ORACLE_SID PROD;
x setenv TWO_TASK PROD;
Proc sql;
connect to oracle as squery1 (user= orapw=);
create table BRPF_01 as
select *
from connection to squery1
( ***Insert***);
disconnect from squery1;
quit;
Ideally, what I would like is for this code to execute, but where it says ***Insert*** it would call the queries that I need to run. I was attempting to use %include, but I was unable to get that to run within the Proc SQL. Is there another way? Or a way to get it to call all the scripts within a certain folder?
Thanks!