topic Re: How to call a sas program inside a macro function in Advanced Programming

How to call a sas program inside a macro function

alepage — Tue, 24 Nov 2020 16:24:43 GMT

%macro add_new_year_in_cal;
%global Path;

%let Path=/dwh_operation/sasprocess/smp_production/prod_smpi2/sasmacro/;

OPTIONS SASAUTOS=("&Path.");

%localizepilottbl;

%include "&Path.update_trigger.sas";
%put &UpdatePilotTblTrigger.;

%if &UpdatePilotTblTrigger. = 'Y' %then
%do;
%include"&Path.copyfilefromreftosmpi2.sas";
%end;

%mend add_new_year_in_cal;
options mprint;
%add_new_year_in_cal;

Re: How to call a sas program inside a macro function

alepage — Tue, 24 Nov 2020 16:26:45 GMT

the function copyfilefromreftosmpi2.sas is not executed even if the updatepilottbltrigger=Y

Re: How to call a sas program inside a macro function

Kurt_Bremser — Tue, 24 Nov 2020 16:33:55 GMT

Always keep in mind that the macro processor is a text engine and does not need quotes for strings, as everything is a string.
You are testing for 'Y'. If your macro variable does not contain the quotes, the comparison will fail.

Re: How to call a sas program inside a macro function

Reeza — Tue, 24 Nov 2020 16:36:11 GMT

Can you please format your code for legibility and use a code box? It really helps for reading code.

Have you tried removing the quotes in the comparison? I'm fairly certain that's required in macro coding.

%macro add_new_year_in_cal;
%global Path;

%let Path=/dwh_operation/sasprocess/smp_production/prod_smpi2/sasmacro/;

OPTIONS SASAUTOS=("&Path.");

%localizepilottbl;

%include "&Path.update_trigger.sas";
%put &UpdatePilotTblTrigger.;

%if &UpdatePilotTblTrigger. = Y %then
%do;
%include"&Path.copyfilefromreftosmpi2.sas";
%end;

%mend add_new_year_in_cal;

options mprint;
%add_new_year_in_cal;

If that doesn't work, please post your log from your code after adding the MLOGIC option to your OPTIONS statement.

@alepage wrote:
the function copyfilefromreftosmpi2.sas is not executed even if the updatepilottbltrigger=Y