SAS_MACVARS

Concept	Definition
Macro Variables	Macro variables in SAS store text that can be substituted into SAS code dynamically. They are widely used for automation and reducing repetitive coding. Macro variables can be either user-defined or system-defined.
User-Defined Macro Variables	User-defined macro variables are created by users to store custom values that can be reused throughout the program.
System-Defined Macro Variables	System-defined macro variables are provided by SAS and contain environment-specific information such as date, time, or operating system details.

30551  * Sample data for sales dataset ;
30552  data sales_data;
30553      input sale_date :date9. amount department $;
30554      format sale_date date9.;
30555      datalines;
 
NOTE: The data set WORK.SALES_DATA has 4 observations and 3 variables.
NOTE: Compressing data set WORK.SALES_DATA increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
30560  ;
30561  run;
30562
30563  * Sample data for department_sales dataset ;
30564  data department_sales;
30565      input department $ sales;
30566      datalines;
 
NOTE: The data set WORK.DEPARTMENT_SALES has 2 observations and 2 variables.
NOTE: Compressing data set WORK.DEPARTMENT_SALES increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
30569  ;
30570  run;
30571
30572  * Sample data for all_sales dataset ;
30573  data all_sales;
30574      input sale_date :date9. amount;
30575      format sale_date date9.;
30576      datalines;
 
NOTE: The data set WORK.ALL_SALES has 8 observations and 2 variables.
NOTE: Compressing data set WORK.ALL_SALES increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
30585  ;
30586  run;

38068  * Create and use a user-defined macro variable ;
38069  %let report_date = 01JAN2024;
38070
38071  data sales_summary;
38072      set sales_data;
38073      where sale_date = "&report_date"d; * Use macro variable for filtering ;
38074  run;
 
NOTE: There were 2 observations read from the data set WORK.SALES_DATA.
      WHERE sale_date='01JAN2024'D;
NOTE: The data set WORK.SALES_SUMMARY has 2 observations and 3 variables.
NOTE: Compressing data set WORK.SALES_SUMMARY increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
38075
38076  proc print data=sales_summary;
38077      title "Sales Summary for &report_date";
38078  run;
 
NOTE: There were 2 observations read from the data set WORK.SALES_SUMMARY.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

53066  * Use macro variables with iterative processing ;
53067  %macro generate_reports;
53068      %do year = 2020 %to 2023;
53069          data sales_&year;
53070              set all_sales;
53071              where year(sale_date) = &year;
53072          run;
53073
53074          proc print data=sales_&year;
53075              title "Sales Report for &year";
53076          run;
53077      %end;
53078  %mend generate_reports;
53079
53080  %generate_reports;
 
NOTE: There were 2 observations read from the data set WORK.ALL_SALES.
      WHERE YEAR(sale_date)=2020;
NOTE: The data set WORK.SALES_2020 has 2 observations and 2 variables.
NOTE: Compressing data set WORK.SALES_2020 increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE: There were 2 observations read from the data set WORK.SALES_2020.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
 
NOTE: There were 2 observations read from the data set WORK.ALL_SALES.
      WHERE YEAR(sale_date)=2021;
NOTE: The data set WORK.SALES_2021 has 2 observations and 2 variables.
NOTE: Compressing data set WORK.SALES_2021 increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE: There were 2 observations read from the data set WORK.SALES_2021.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
 
NOTE: There were 2 observations read from the data set WORK.ALL_SALES.
      WHERE YEAR(sale_date)=2022;
NOTE: The data set WORK.SALES_2022 has 2 observations and 2 variables.
NOTE: Compressing data set WORK.SALES_2022 increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
NOTE: There were 2 observations read from the data set WORK.SALES_2022.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
 
NOTE: There were 2 observations read from the data set WORK.ALL_SALES.
      WHERE YEAR(sale_date)=2023;
NOTE: The data set WORK.SALES_2023 has 2 observations and 2 variables.
NOTE: Compressing data set WORK.SALES_2023 increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
NOTE: There were 2 observations read from the data set WORK.SALES_2023.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

*Copyright @ www.mycsg.in;

Understanding Macro Variables in SAS

Why Do We Need Macro Variables?

Create Sample Data

Creating and Using User-Defined Macro Variables

Examples of System-Defined Macro Variables

Using Macro Variables in Titles and Labels

Using Macro Variables with Iterative Processing