PROC SQL NOPRINT default value

[fabdu92]

Hi,

Is there any way to have a default value for a PROC SQL NOPRINT if no matching row is found?

Thanks

[RW9]

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?  

[fabdu92]

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.

[ballardw · Accepted solution]

I would say the easiest is to add

%let p_rate=1;

just before the proc sql. If a value is selected in the SQL then it wll overwrite the value assigned with the %let.

[fabdu92]

This is so easy that I even didn't think to this! ^^ Thanks