topic Re: Macro question in SAS Programming

Macro question

zimcom — Wed, 04 Mar 2020 19:38:27 GMT

Greeting!

I receieved a SAS program codes which has a few Marco statements.

%setup;

......

%sumcat5(datin=adqs3, clsvar=trt01pn, byvars=avisitn, anvar=aval);

......

When I run the code, I got the following warning and error message when I come to the above Marco statement.

WARNING: Apparent invocation of macro SETUP not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order.

I don't know much about the Marco, I want to know how I can run the code and what is missing

Thanks

Re: Macro question

novinosrin — Wed, 04 Mar 2020 19:42:13 GMT

%setup is a macro call that you would use to execute compiled macro code.

Do you know whether

%macro setup;

-------

-----

%mend setup;

Has been compiled previously ?

Re: Macro question

zimcom — Wed, 04 Mar 2020 19:44:44 GMT

I dont know, but how?

Re: Macro question

ballardw — Wed, 04 Mar 2020 19:44:47 GMT

Somewhere you need to find the code that define the macro setup. Then compile that before running the code you show.

The code would look something like:

%macro setup();

%mend;

Highlight the code and then run it to compile the macro. You may need to do this for other macro definitions as well.

If you can't find that definition code go back to the source and search or inquire about the definition code.

Re: Macro question

Tom — Wed, 04 Mar 2020 19:47:01 GMT

Before you can call %SETUP you need to define it.

Most likely the original user was using autocall facility to have SAS find and compile the macro source. You can set the SASAUTOS option to point to one or more directories and when SAS does not already have a macro with the name your code is using, say SETUP, defined it will look for a file with the same name as the macro, so 'setup.sas', in the SASAUTOS search path and include the code in that file.

Or there might be one large file that defines all of the macros that the program assumed had already been run when the SAS session was started.

So look for the code that starts with %MACRO SETUP and ends with %MEND statement. That is the definition or the macro. If you run that code it should just compile the macro so that is available to be called. Once the macro is defined your other code can use it.

Re: Macro question

novinosrin — Wed, 04 Mar 2020 19:47:04 GMT

Hmm, you would need to find out the location where the macro is stored/saved. Perhaps, you could ask your teammates/or even boss? 🙂

Re: Macro question

zimcom — Wed, 04 Mar 2020 19:47:43 GMT

So I need to go back to the original SAS programmer who initially wrote this SAS program to ask for Marco setup code?

Re: Macro question

Tom — Wed, 04 Mar 2020 19:50:41 GMT

Yes.

From the name it sounds like they have system of macros they have created. So the SETUP macro will set your SAS session into the standard environment that they like to use. Probably defining standard libref, filerefs, options etc.

Hopefully they have documentation of how they work and how you can use them.

Re: Macro question

zimcom — Wed, 04 Mar 2020 20:03:17 GMT

@Tom @novinosrin @ballardw This is very helpful and I will reach out to the original programmer and find out if he can send me the Marco setup file. Thank you all again, your continuous help and support make my SAS learning possible.

Re: Macro question

ballardw — Wed, 04 Mar 2020 23:32:51 GMT

@Tom wrote:

Before you can call %SETUP you need to define it.

Most likely the original user was using autocall facility to have SAS find and compile the macro source. You can set the SASAUTOS option to point to one or more directories and when SAS does not already have a macro with the name your code is using, say SETUP, defined it will look for a file with the same name as the macro, so 'setup.sas', in the SASAUTOS search path and include the code in that file.

Or there might be one large file that defines all of the macros that the program assumed had already been run when the SAS session was started.

So look for the code that starts with %MACRO SETUP and ends with %MEND statement. That is the definition or the macro. If you run that code it should just compile the macro so that is available to be called. Once the macro is defined your other code can use it.

A Comment I often place in my code that uses some of my custom utility macros is that the macros are in a folder that has been added to the Autocall path on my system. So folks that come after me when I strike it rich at the lottery have some chance of finding the code.

Of course they may have to find my Autoexec.SAS file to find that path ...

Re: Macro question

zimcom — Wed, 04 Mar 2020 23:48:20 GMT

Thanks for the insight, after today’s discussion I kind of have an idea of Marco code now. I have requested from the original programmer for the marco code. I am solo SAS user in the entire company and I learned a lot of things from here, I just want to say that I appreciated your help so much !!!

Re: Macro question

zimcom — Thu, 05 Mar 2020 15:20:29 GMT

%sumcat5(datin=adqs3, clsvar=trt01pn, byvars=avisitn, anvar=aval);

"Yes, that summarizes the data and puts it in a format for the .rtf file. It is not required for the proc logistic analysis. You can get the summary statistics by replacing it with a proc freq."

@ballardw @Tom @novinosrin

I got reply and not quite sure how to replace the above marco with a proc freq, would you be able to provide any insight on this?

Re: Macro question

Tom — Thu, 05 Mar 2020 16:14:32 GMT

@zimcom wrote:

%sumcat5(datin=adqs3, clsvar=trt01pn, byvars=avisitn, anvar=aval);

"Yes, that summarizes the data and puts it in a format for the .rtf file. It is not required for the proc logistic analysis. You can get the summary statistics by replacing it with a proc freq."

@ballardw @Tom @novinosrin

I got reply and not quite sure how to replace the above marco with a proc freq, would you be able to provide any insight on this?

You need to ask more or figure out what output you want . Looks like you might use the DATIN value as the DATA= value, BYVARS values on a BY statement, CLSVAR and ANVAR in the TABLES statement.

proc freq data=adqs3 ;
  by avisitn;
  tables trt01pn*aval;
run;