topic Re: write a macro in excel and execute it in base sas in New SAS User

write a macro in excel and execute it in base sas

lc7033907 — Sun, 21 Feb 2021 18:25:40 GMT

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.

Re: write a macro in excel and execute it in base sas

Kurt_Bremser — Sun, 21 Feb 2021 19:44:25 GMT

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.

Re: write a macro in excel and execute it in base sas

lc7033907 — Mon, 22 Feb 2021 03:56:00 GMT

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