SAS has a powerful programming feature called Macros which allows us to avoid repetitive sections of code and to use them again and again when needed. It also helps create dynamic variables within the code that can take different values for different run instances of the same code. Macros can also be declared for blocks of code which will be reused multiple times in a similar manner to macro variables. We will see both of these in the below examples.

Macro variables

These are the variables which hold a value to be used again and again by a SAS program. They are declared at the beginning of a SAS program and called out later in the body of the program. They can be Global or Local in scope.

Global Macro variable

They are called global macro variables because they can accessed by any SAS program available in the SAS environment. In general they are the system assigned variables which are accessed by multiple programs. A general example is the system date.

Example

Below is a example of the SAS variable called SYSDATE which represents the system date. Consider a scenario to print the system date in the title of the SAS report every day the report is generated. The title will show the current date and day without we coding any values for them. We use the in-built SAS data set called CARS available in the SASHELP library.

proc print data = sashelp.cars;

where make = 'Audi' and type = 'Sports' ;

TITLE "Sales as of &SYSDAY &SYSDATE";

run;

When the above code is run we get the following output.

Local Macro variable

These variables can be accessed by SAS programs in which they are declared as part of the program. They are typically used to supply different varaibels to the same SAS statements sl that they can process different observations of a data set.

Syntax

The local variables are decalred with below syntax.

% LET (Macro Variable Name) = Value;

Here the Value field can take any numeric, text or date value as required by the program. The Macro variable name is any valid SAS variable.

Example

The variables are used by the SAS statements using the & character appended at the beginning of the variable name. Below program gets us all the observation of the make ‘Audi’ and type ‘Sports’. In case we want the result of different make, we need to change the value of the variable make_name without changing any other part of the program. In case of bring programs this variable can be referred again and again in any SAS statements.

%LET make_name = 'Audi';

%LET type_name = 'Sports';

proc print data = sashelp.cars;

where make = &make_name and type = &type_name ;

TITLE "Sales as of &SYSDAY &SYSDATE";

run;

When the above code is run we get the same output as the previous program. But let’s change the type name to ‘Wagon’ and run the same program. We will get the below result.

Macro Programs

Macro is a group of SAS statements that is referred by a name and to use it in program anywhere, using that name. It starts with a %MACRO statement and ends with %MEND statement.

Syntax

The local variables are declared with below syntax.

# Creating a Macro program.
%MACRO <macro name>(Param1, Param2,….Paramn);
Macro Statements;
%MEND;

# Calling a Macro program.
%MacroName (Value1, Value2,…..Valuen);

Example

The below program decalres a group of SAT staemnets under a macro named ‘show_result’; This Macro is being called by other SAS statements.

%MACRO show_result(make_ , type_);
proc print data = sashelp.cars;
where make = "&make_" and type = "&type_" ;
TITLE "Sales as of &SYSDAY &SYSDATE";
run;
%MEND;

%show_result(BMW,SUV);

When the above code is run we get the following output.

Commonly Used Macros

SAS has many MACRO statements which are in-built in the SAS programming language. They are used by other SAS programs without explicitly declaring them.Common examples are – terminating a program when some condition is met or capturing the runtime value of a variable in the program log. Below are some examples.

Macro %PUT

This macro statement writes text or macro variable information to the SAS log. In the below example the value of the variable ‘today’ is written to the program log.

data _null_;

CALL SYMPUT ('today',

TRIM(PUT("&sysdate"d,worddate22.)));

run;

%put &today;

When the above code is run we get the following output.

Macro %RETURN

Execution of this macro causes normal termination of the currently executing macro when certain condition evaluates to be true. In the below examplewhen the value of the variable “val” becomes 10, the macro terminates else it contnues.

%macro check_condition(val);
%if &val = 10 %then %return;
data p;
x = 34.2;
run;
%mend check_condition;
%check_condition(11)  ;

When the above code is run we get the following output.

Macro %END

This macro definition contains a %DO %WHILE loop that ends, as required, with a %END statement. In the below example the macro named test takes a user input and runs the DO loop using this input value. The end of DO loop is achieved through the %end statement while the end of macro is achieved through %mend statement.

%macro test(finish);
%let i = 1;
%do %while (&i <&finish);
%put the value of i is &i;
%let i=%eval(&i+1);
%end;
%mend test;
%test(5)

When the above code is run we get the following output.

So, this brings us to the end of blog. This Tecklearn ‘SAS – Macros’ blog helps you with commonly asked questions if you are looking out for a job in SAS. If you wish to learn SAS and build a career in Data Analytics domain, then check out our interactive, SAS Training for SAS BASE Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sas-training-for-sas-base-certification/

SAS Training for SAS BASE Certification Training

About the Course

SAS Certification Training is intended to make you an expert in SAS programming and Analytics. You will be able to analyse and write SAS code for real problems, learn to use SAS to work with datasets, perform advanced statistical techniques to obtain optimized results with Advanced SAS programming. In this SAS online training course, you will also learn SAS macros, Machine Learning, PROC SQL, procedure, statistical analysis and decision trees. You will also work on real-life projects and prepare for the SAS Certified Base Programmer certification exam. Upon the completion of this SAS online training, you will have enough proficiency in reading spreadsheets, databases, using SAS functions for manipulating this data and debugging it.

Why Should you take SAS Training?

The average salary for a Business Intelligence Developer skilled in SAS is $100k (PayScale salary data)
SAS, Google, Facebook, Twitter, Netflix, Accenture & other MNCs worldwide are using SAS for their Data analysis activities and advance their existing systems.
SAS is a Leader in 2017 Gartner Magic Quadrant for Data Science Platform.

What you will Learn in this Course?

Introduction to SAS

Introduction to SAS
Installation of SAS
SAS windows
Working with data sets
Walk through of SAS windows like output, search, editor etc

SAS Enterprise Guide

How to read and subset the data sets
SET Statement
Infile and Infile Options
SAS Format -Format Vs Informat

SAS Operators and Functions

Using Variables
Defining and using KEEP and DROP statements
Output Statement
Retain Statement
SUM Statement

Advanced SAS Procedures

PROC Import
PROC Print
Data Step Vs Proc
Deep Dive into Proc

Customizing Datasets

SAS Arrays
Useful SAS Functions
PUT/INPUT Functions
Date/Time Functions
Numeric Functions
Character Functions

SAS Format and SAS Graphs

SAS Format statements
Understanding PROC GCHART, various graphs, bar charts: pie, bar

Sorting Techniques

NODUP
NODUKEY
NODUP Vs NODUKEY

Data Transformation Function

Character functions, numeric functions and converting variable type
Use functions in data transformation

Deep Dive into SAS Procedures, Functions and Statements

Find Function
Scan Function
MERGE Statement
BY Statement
Joins
Procedures Vs Function
Where Vs If
What is Missover
NMISS
CMISS

PROC SQL

SELECT statement
Sorting of Data
CASE expression
Other SELECT statement clauses
JOINS and UNIONS

Using SAS Macros

Benefits of SAS Macros
Macro Variables
Macro Code Constituents and Macro Step
Positional Parameters to Macros

Got a question for us? Please mention it in the comments section and we will get back to you.

667