04-04-2017 11:44 AM
Erm, the NOPRINT option stops SQL printing things to the log when there is just a select clause. What exactly are you after, do you mean stop the procedure results, that is pretty default for all procedures?
04-04-2017 11:53 AM
Thanks for the answer RW9
PROC SQL NOPRINT; SELECT arn INTO: p_rate FROM rates WHERE MONTH(date) = MONTH("&chosendate."d); QUIT; RUN;
I am doing something like this. I use p_rate in the following like a calculation parameter.
If there is no matching rows, I would like p_rate to be equals to 1 by default...like this the rate won't have impact on the calculation.
Need further help from the community? Please ask a new question.