topic Re: Proc Print before Abort in SAS Procedures

Proc Print before Abort

MartyMcFlySAS — Thu, 05 Nov 2020 02:01:24 GMT

I am using Eguide. Right now the following code does what it is supposed to do: it aborts the query if a condition is met. But the log appears after the Abort. Instead I want to run a Proc Print of a dataset called ANIMALS that remains on screen instead of the screen showing the log. Is this possible? Thank you.

%MACRO MYMACRO();

PROC SQL;

%CONNECT_DB(MYSERVER, LIBNAME=YES);

%IF "&CAT." NE "" and "&DOG." NE "" %THEN %DO;

%PUT ERROR: CAT and DOG cannot both be empty.;

%ABORT;

%END;

..rest of code....

Re: Proc Print before Abort

Kurt_Bremser — Thu, 05 Nov 2020 07:23:17 GMT

From where do the macro variables &dog and &cat originate? What does the macro connect_db contain?

Re: Proc Print before Abort

MartyMcFlySAS — Thu, 05 Nov 2020 10:40:40 GMT

Disregard, I figured it out. I will not use the Abort function, instead I will wrap the entire code in an %IF statement.