Calling a Macro from another program - it is possible and it is useful

[ph10]

I am doing a Macro to deal with datas for an analysis.

And i have two doubts albout dealing with erros, like the data is not avalible, and others

1)     It is possible to create a Macro(functrion)  that is write in another program that is is the same process flow. How to doi it?

2)     if the first option it is true, if we have any better doing this.

T

[PaigeMiller]

If you create a program that contains a macro, there are two different ways (maybe more, actually) to use it inside another program. Let's say you have created a macro named %MYMACRO and stored the code for this macro as c:\myfolder\mymacro.sas

Method 1: in your other program, use: %include "c:\myfolder\mymacro.sas";

Method 2:  in your other program, use: options sasautos=(sasautos "c:\myfolder");

In either case, %MYMACRO will now run your macro in the other program

[ph10]

Hello PaigeMiler,

       Thanks for the answer, but i had a problem doing the first option. 

       I exported the programa to C:\Users\f8118809\Documents.

       And came this option:

WARNING: Physical file does not exist, /opt/sas94config_anl03/Lev1/SASApp_ANL03/C:\Users\f8118809\Documents\producao.sas.
ERROR: Cannot open %INCLUDE file C:\Users\f8118809\Documents\producao.sas.

[PaigeMiller]

You have given SAS the wrong folder name and/or the wrong file name where the SAS program with the macro is located.

[Reeza]

Looks like you're using a server. You need to have the server path for the file, not your local path.

---

@ph10 wrote:

Hello PaigeMiler,

       Thanks for the answer, but i had a problem doing the first option. 

       I exported the programa to C:\Users\f8118809\Documents.

       And came this option:

WARNING: Physical file does not exist, /opt/sas94config_anl03/Lev1/SASApp_ANL03/C:\Users\f8118809\Documents\producao.sas.
ERROR: Cannot open %INCLUDE file C:\Users\f8118809\Documents\producao.sas.

---

[ph10]

Reeza,

           Thanks now it is working.