topic PROC SQL NOPRINT default value in SAS Procedures

PROC SQL NOPRINT default value

fabdu92 — Tue, 04 Apr 2017 15:32:53 GMT

Hi,

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

Thanks

Re: PROC SQL NOPRINT default value

RW9 — Tue, 04 Apr 2017 15:44:36 GMT

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?

Re: PROC SQL NOPRINT default value

fabdu92 — Tue, 04 Apr 2017 15:53:24 GMT

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.

Re: PROC SQL NOPRINT default value

ballardw — Tue, 04 Apr 2017 16:08:47 GMT

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.

Re: PROC SQL NOPRINT default value

fabdu92 — Tue, 04 Apr 2017 16:12:39 GMT

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