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?
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:
options
insert=(SASAUTOS=("D:\Data"))
;
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.
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:
http://lexjansen.com/search/searchresults.php?q=introduction%20to%20macros
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.