topic Re: Kindly help to resolve this code in SAS Programming

Kindly help to resolve this code

ankitk321 — Thu, 30 Aug 2018 15:34:23 GMT

%if (%upcase(%trim("&Include_Exclude")) NE "INCLUDE") OR (%upcase(%trim("&Include_Exclude")) NE "EXCLUDE") OR (%upcase(%trim("&Include_Exclude")) NE "ALL DATASETS") %then %do;

%message(Fatel Error:Values in Include/Exclude Dataset is not correct^20);

%goto exit;

%end;

value of Include_Exclude macro variable is "Include". I want if value is not equal to INCLUDE then exit macro. but it is not getting resolved and not giving correct result

I have tried following-:

1.Removing quotes from the macro variable and the value. for example --> (%upcase(%trim(&Include_Exclude)) NE INCLUDE)

2. I have tried removing trim

But still not able to get the desired result.

Kindly help me to solve the same.

Re: Kindly help to resolve this code

Astounding — Thu, 30 Aug 2018 15:51:00 GMT

Macro language does not require quotes to identify character strings. Because you added them, %TRIM is doing nothing. Best to get rid of them.

When you join three conditions using OR, one (or more) of the comparisons must be true. The comparisons should use AND instead of OR:

%if %upcase(&Include_Exclude) NE INCLUDE

AND %upcase(&Include_Exclude) NE EXCLUDE

AND %upcase(&Include_Exclude) NE ALL DATASETS %then %do;

If you are truly concerned about the value of &INCLUDE_EXCLUDE containing special characters or special words, switch from %UPCASE to %QUPCASE.

Re: Kindly help to resolve this code

Amir — Thu, 30 Aug 2018 16:00:33 GMT

Hi,

If you are seeing a message in the log such as:

WARNING: Apparent symbolic INCLUDE_EXCLUDE reference not resolved.

then you might have a global vs local scope issue. If this is the case then try using the statement:

%global include_exclude;

before the variable is first used so that it can be accessed elsewhere.

If this is not the case then please share more of the log.

You might want to also consider changing the or conditions to and conditions as your test ends up being:

"INCLUDE" ne "INCLUDE"

or "INCLUDE" ne "EXCLUDE"

or "INCLUDE" ne "ALL DATASETS"

which evaluates to:

FALSE

or TRUE

which gives TRUE. Using and instead of or would give FALSE.

Regards,

Amir.