Hello: I have 6 separate datasets. I want to upload each of these datasets and create 6 different oracle tables. I have a macro in which I am attempting to execute Do loop in Proc SQL: %let count = 6; libname lob '/xxx/xxx/xxx/Data'; libname khalke oracle user=&xxx password="&xxx" path="&xxx" schema=&xxx; %Macro fileupload; proc sql; %do i = 1 %to &count; create table khalke.test_xxx_d209file_T&count as select * from lob.test_xxx_d209file&count order by actnmbr; %end; quit; %mend; %fileupload; However, I am getting the following error message: %let count = 6; libname lob '/xxx/xxx/xxx/Data'; NOTE: Libref LOB was successfully assigned as follows: Engine: V9 Physical Name: /xxx/xxx/xxx/Data libname khalke oracle user=&xxx password="&xxx" path="&xxx" ! schema=&xxx; NOTE: Libref KHALKE was successfully assigned as follows: Engine: ORACLE Physical Name: WFPROD %Macro fileupload; proc sql; %do i = 1 %to &count; create table khalke.test_xxxx_d209file_T&count as select * from lob.test_xxxx_d209file&count order by actnmbr; %end; quit; %mend; ERROR: There were 1 unclosed %DO statements. The macro FILEUPLOAD will not be compiled. ERROR: A dummy macro will be compiled. %fileupload; - 180 WARNING: Apparent invocation of macro FILEUPLOAD not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. Thank you.
... View more