BookmarkSubscribeRSS Feed
Calcite | Level 5

Hi there,

I'm new to SAS macro.

What is the correct way to run a SAS macro?

Do I first of all run the macro definition first?(highlight from %MACRO all the way to %MEND), then I go to the main program to call it?


just call from the main program?

below is the code: (this is after an Excel file importation). Attached file is the Enterprise Guide file.

Thank you

Super User Tom
Super User

Your code looks fine other than that the data step is missing a RUN; statement to tell SAS that you are done typing the code.

Add a run statement after the last of the macro calls.

Calcite | Level 5

thanks. I'm moving on

Super User

The macro defnition does need to be "compiled" before use. This is typically done by executing the definition code. However if a macro is not changing and is used frequently you may want to investigate a macro AUTOCALL LIBRARY. This is basically a folder or directory that SAS will look iin if you attempt to execute an unknown macro call to find a macro by that name an then compile as needed.

Calcite | Level 5

thanks. I'm moving on. Will look into the autocall sometimes.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 3 in conversation