topic Re: Macros not resolving when executing campaigns in SAS CIS in SAS Studio

Macros not resolving when executing campaigns in SAS CIS

ath_123 — Thu, 24 Nov 2016 09:36:36 GMT

Hi All,

We are executing a SAS DI job in batch mode and the job is completed successfully. But when we execute the sas job through SAS CIS by executing a campaign the jobs log shows error like "Macro not resolved". The macro paths are kept in autoexec file. This is happening with all the macros and macro variables .

Kindly help us on this.

Thanks in Advance

Re: Macros not resolving when executing campaigns in SAS CIS

Kurt_Bremser — Thu, 24 Nov 2016 09:44:00 GMT

Look at the logs, especially the part where the autoxec is executed. It might be that the system user that runs CIS does not have the necessary permissions to read the includes.

Re: Macros not resolving when executing campaigns in SAS CIS

ath_123 — Thu, 24 Nov 2016 10:03:33 GMT

Hi,

We are getting below error.

NOTE: Autocall member, WRITEHEADER, has not been compiled by the macro processor. It might contain a macro syntax error or not define a macro with the same name as the member. To autocall
this member again, set OPTION MRECALL.
MPRINT(FLUSSI_OUTPUT): ();
345 %writeheader();
_
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: Macros not resolving when executing campaigns in SAS CIS

Kurt_Bremser — Thu, 24 Nov 2016 10:16:14 GMT

Are you using the autocall facility also in DI batch jobs, or are you simply including the files there?

And is the file where the macro %writeheader is defined named writeheader.sas?

Re: Macros not resolving when executing campaigns in SAS CIS

ath_123 — Thu, 24 Nov 2016 11:11:01 GMT

Yes we are using autocall only.. Macro path is included in autoexec. The name of macro is same as the .sas name. Also, the same issue is coming for all the macros and macro variables used in the job.

Re: Macros not resolving when executing campaigns in SAS CIS

Kurt_Bremser — Thu, 24 Nov 2016 11:22:26 GMT

On which system platform are you running SAS (the server part)?

Re: Macros not resolving when executing campaigns in SAS CIS

ath_123 — Thu, 24 Nov 2016 11:28:40 GMT

We are using UNIX platform.

Re: Macros not resolving when executing campaigns in SAS CIS

Kurt_Bremser — Thu, 24 Nov 2016 11:38:52 GMT

Could you post the code for the %writeheader macro here, or does it contain sensitive information?

Re: Macros not resolving when executing campaigns in SAS CIS

ath_123 — Thu, 24 Nov 2016 11:55:07 GMT

Yes it does have sensitive information

Re: Macros not resolving when executing campaigns in SAS CIS

Kurt_Bremser — Thu, 24 Nov 2016 12:19:09 GMT

There's surprisingly little in the SAS knowledge base to be found for this NOTE, and that is related to z/OS.

So the only thing that's left from my POV is some difference between the two environments (user permissions, option settings) that makes the macro syntactically or semantically wrong in the CIS.

In any case, I'd put the issue to SAS technical support. With them, it's easier to reveal the code.