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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.