write a macro in excel and execute it in base sas

[lc7033907]

Hello everyone,

I have a question about executing macro which is stored in an excel file. For example, here is my macro:

%macro ttl_fnt;
 title1  "Table 1" ;
 title2  "for height and weight of each group";
 footnote1   j=left "Study program 1"  
             j=right "Page 1 of 10";
 footnote2   j=left "Version &sysver"  
             j=right "Date: &sysdate9";
%mend ttl_fnt;

It's saved in excel and then I want to execute it in programming with base SAS. How to do it? 

I don't want to just put titles and footnotes in my sas, because I have several projects with same titles and footnotes except title1. Any suggestion is appreciated.

[Kurt_Bremser · Accepted solution]

Save your code in text files with a .sas extension, and use the %include statement to use it in a SAS program. Or (as it is a macro), use the autocall facility to make it available without including.

[lc7033907]

Thank you so much, KurtBremser. I'll try your both ways.