Can't - I am doing a mass connection test. I need the macro to loop thru the input file that contains many database types, userids, passwords, schemas, etc. ... View more

Ok - So I moved my global var definition downwhere I am doing the libstat&I assignment, and now it works.  Thank you!   %MACRO test_connection(); %DO I = 1 %TO &IDS; %IF "&&type&I." EQ "DB2" /* success*/ %THEN %DO; LIBNAME DB2TST DB2 DATAsrc="&&datasrc&i." USER="&&user&i." PASSWORD="&&pwd&i." SCHEMA="&&schema&i." access=readonly; /* Trap error here. What code can trap an error, if it occurs, and make it available to the rest of the SAS program? */ %put &=syslibrc; %global libstat&I; %let libstat&I = syslibrc; %END; %END; %RUN; %MEND test_connection; %test_connection(); data work.fail; do i=1 to &ids; x=symget("libstat"|| cat(I)); if x ^=0 then output; end; run; Proc export data=work.fail; outfile="/mydir/fail.xlsx" dbms=XLSX replace; run; ... View more

These are the coding changes I made, but I my libstat&I isn't being assigned anything...what could possible sytax corrections be for this line:   %let libstat&I = syslibrc; x=symget("libstat"|| cat(I)); - x has nothing in it. %MACRO test_connection(); %global libstat&I; %DO I = 1 %TO &IDS; %IF "&&type&I." EQ "DB2" /* success*/ %THEN %DO; LIBNAME DB2TST DB2 DATAsrc="&&datasrc&i." USER="&&user&i." PASSWORD="&&pwd&i." SCHEMA="&&schema&i." access=readonly; /* Trap error here. What code can trap an error, if it occurs, and make it available to the rest of the SAS program? */ %put &=syslibrc; %let libstat&I = syslibrc; %END; %END; %RUN; %MEND test_connection; %test_connection(); data work.fail; do i=1 to &ids; x=symget("libstat"|| cat(I)); if x ^=0 then output; end; run; Proc export data=work.fail; outfile="/mydir/fail.xlsx" dbms=XLSX replace; run; ... View more

Thank you! But how to I get it into a variable and available to the rest of the SAS program (not just a put to the log)? I ultimately need to output failures to an excel sheet... ... View more