topic Re: SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc; in SAS Programming

SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc;

JMarkW — Mon, 15 Sep 2008 13:30:42 GMT

Does anybody know exactly how the %if (1) %then %let sqlldr_rc=&sysrc line works?

I'm not familiar with %if (1)

Re: SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc;

deleted_user — Mon, 15 Sep 2008 13:44:40 GMT

Expression in %if can be any valid macro expression that resolves to an integer. If expression is evaluated to zero, then it is false and the %then text is not processed. If it resoles to any integer other than zero, then the expression is true, and the %then text is processed. If it resolves to null or to any noninteger value, an error message is issued.

Re: SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc;

sbb — Mon, 15 Sep 2008 13:45:14 GMT

The SAS macro code is using a technique to force a TRUE condition test result. A value of 1 is TRUE and a value of 0 is false. You can see this processing decision during SAS code compilation if you turn on:

options source source2 macrogen symbolgen mlogic;

Scott Barry
SBBWorks, Inc.

Re: SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc;

LinusH — Mon, 15 Sep 2008 13:45:35 GMT

In conditional logic, 1 means TRUE. So your %if will always be true, and the assignment of sqlldr_rc will always happen.

/Linus

Re: SQLLDR followed by %if (1) %then %let sqlldr_rc=&sysrc;

JMarkW — Mon, 15 Sep 2008 14:10:00 GMT

Thanks! I didn't expect the (1) to force a true test result. I'm not sure why the programmer didn't just code

%let sqlldr_rc=&sysrc;

Maybe this is a little slop accidently left in the code.