topic Re: Call include statement within Macro if/else if in SAS Enterprise Guide

Call include statement within Macro if/else if

Bensansing — Thu, 20 Aug 2015 20:34:29 GMT

Hey all,

I am trying to call a different include statement inside of a macro, but having the include different based on if a different macro is selected

ex:

%macro DDL;

%if &upd = 2 or &upd = 4 or &upd = 5 %then %do;

%include "/test/&csv..sas";

%end;

%else %do;

%include "/test/&fn..sas";

%end;

%mend DDL;

%DDL

Inside each of those is a different macro that needs to be used in a proc sql statement, but when I put this logic in my program is not reading the macor &Query

But when I had it just this it would work: %include "/test/&fn..sas";

Not sure it's including it from the macro.. any thoughts?

Thanks

Re: Call include statement within Macro if/else if

ballardw — Fri, 21 Aug 2015 15:53:12 GMT

Unless those include files have identically named macros (and nothing else) with different behavior I would suggest you are spending a lot of time for not much reward. And if you do have the same named macro in each that is generally not a good idea. If they do different things they should have a different name.

Since compiling macros takes relatively few processes, include all of the macro source code at the start of the job, or investigate AUTOCALL macro libraries.

Are you getting errors? What value(s) of UPD that is causing the problem?

Have you run this with OPTIONS MPRINT SOURCE2;