Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 16
Program 16a
Copying rows from a DICTIONARY table

DICTIONARY tables are available only in SQL. Use SQL statements to copy selected values to new tables to make them available for data step programming.

---

*
  Professional SAS Programming Secrets
  Program 16a
  Copying rows from a DICTIONARY table
*;

proc sql;
create table work.pageoptions as
    select * from dictionary.options
    where optname in ('LINESIZE', 'PAGESIZE', 'CENTER', 'DATE', 'NUMBER')
    order by optname;
quit;