Hi, I have a task where I need to read multiple texts files containing SQLs from a shared location on SAS studio and dump/export the output to a folder in SAS only. I am able to pick, read and run one .text file containing a SQL and export that to a folder. But how do I do if I have like 10 .text files present in the input location. Please help on this. data _null_; *reading the SQL script into a variable, hopefully under 32767?; infile "/dslanalytics-shared/dgupt12/SQLs/Query.txt" recfm=f lrecl=32767 pad; input @1 sqlcode $32767.; call symputx('sqlcode',sqlcode); *putting it into a macro variable; run; proc sql; connect to odbc as mycon (complete="DRIVER={SnowflakeDSIIDriver}; SERVER=; UID=&usr.; PWD=&pwd.; WAREHOUSE=; DATABASE=; SCHEMA=; dbcommit=10000 autocommit=no readbuff=200 insertbuff=200;"); create table final_export as select * from connection to mycon(&sqlcode.); disconnect from mycon; quit; proc export data = work.final_export outfile = "/dslanalytics-shared/dgupt12/Report/final_report.csv" DBMS = csv REPLACE; run;
... View more