topic Some macro function works only after reboot of SAS in Administration and Deployment

Some macro function works only after reboot of SAS

Kayalvizhi — Thu, 11 May 2017 13:59:49 GMT

Hi,

Some of the macro function like %compress , %eval , are malfunctioning.

But after reboot of SAS server it got fixed automatically.Can you please let me know the reason behind this issue.

I'm Using: SAS 9.3

In the below scenario %eval function works differently .

Below is the log :

SYMBOLGEN: Macro variable PGM_TYPE resolves to qc

SYMBOLGEN: Macro variable VALID_WH resolves to elig med rx qc export checks prv care onewagexport

MLOGIC(RUN): %IF condition %eval(&pgm_type in &valid_wh.) = 0 is TRUE

SYMBOLGEN: Macro variable PGM_TYPE resolves to qc

SYMBOLGEN: Macro variable VALID_WH resolves to elig med rx qc export checks prv care onewagexport

MLOGIC(RUN): %IF condition %eval(&pgm_type in &valid_wh.) = 0 is FALSE

Thanks,

Kayalvizhi

Re: Some macro function works only after reboot of SAS

Astounding — Thu, 11 May 2017 14:07:50 GMT

The IN operator in macro language can be tricky (obviously?). One possibility in the case you describe ... there will be a default value for the MINDELIMITER option. If it's a blank, that would work when you restart your code since you have blanks between the items in your list. But if your earlier code re-set the MINDELIMITER to some other character, the logic would no longer find a match.

Re: Some macro function works only after reboot of SAS

Kayalvizhi — Fri, 12 May 2017 06:56:12 GMT