DATA Step, Macro, Functions and more

SAS Macros

Frequent Contributor
Posts: 112

SAS Macros

Can someone help me how to learn about macros for SAS from scratch? How to get started and used. 

Would you recommend any paper or material that would be great. 

The next question would be 

How we can store in the library and use it when it needed? 


Super User
Posts: 13,304

Re: SAS Macros

First would be to become fairly familiar with basic SAS programming language, such a completion of the Programming 1 course before getting involved with macros at all. Macros only generate SAS code, so knowing what code to generate is key.


Easier than storing compiled macros may be to use the Autocall facility which would point to the location of code files with macros. Compiled macros are stored in catalogs and not very transferable between operating systems (or versions of SAS sometimes).

Autocall involves setting one value and possibly adding your custom location to the search path.


For instance in my autoexec sas file I have:




which tells SAS to look for my custom macros at D:\Data and compiles them as needed. Insert is so that location is added to the list of locations that SAS already maintains internally for its own macros.

Super User
Posts: 23,262

Re: SAS Macros

There's a specific SAS course, Programming 3 I believe that covers this. 


If you're not interested in the official courses there are tons of user papers/tutorials here:

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation