how can i create a temporary table (stored in a data-warehouse that i am accessing using oracle and proc sql) here is the schematic of my problem proc sql; connect to oracle with tableA as (select * from databaseA-in-datawarehouse); select * from databaseB-in-datawarehouse Join TableA On certain condition disconnect from oracle Thank you ! ... View more

I have a rather straight forward questions. lets assume i am using proc sql to create tables/data sets and save them into a machine. suppose i have created the following files to collect my data : sqlquery1.sas , sqlquery2.sas, sqlquery3.sas, sqlquery4.sas sqlquery1.sas  and sqlquery2.sas can be run in parallel sqlquery3.sas  needs data from sqlquery1.sas  and sqlquery2.sas and should be run after they are finished sqlquery4.sas  needs data from sqlquery3.sas and should start after sqlquery3.sas is finished. I know if i create a sas file with the following commands %include "~/sqlquery1.sas"; %include "~/sqlquery2.sas"; %include "~/sqlquery3.sas"; %include "~/sqlquery4.sas"; the files are going to be run in sequence. Is there a way to specify certain jobs to run in parallel while others to wait ? Thank you, ... View more