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....
From where do the macro variables &dog and &cat originate? What does the macro connect_db contain?
Disregard, I figured it out. I will not use the Abort function, instead I will wrap the entire code in an %IF statement.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.