Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 16
Program 16b
Creating a macro variable from a DICTIONARY table

Use the INTO clause in SQL to create macro variables. This example creates the macro variable COMPRESSION with a specific value selected from a DICTIONARY table.

---

*
  Professional SAS Programming Secrets
  Program 16b
  Creating a macro variable from a DICTIONARY table
*;

proc sql noprint; 
select compress 
    into :compression
    from dictionary.tables
    where libname = 'MAIN' and memname = 'PENDING'; 
quit;