SAS Programming for Enterprise Guide Users, Second Edition

Table of contents

1. Copyright
2. Foreword
3. Acknowledgments
4. 1. Why Do I Need to Write Code?
   1. Introduction
   2. A Brief History of SAS
      1. SAS: A Complete Programming Language
      2. SAS Enterprise Guide: A Graphical User Interface for SAS
      3. So How Does SAS Enterprise Guide Work?
         1. SAS Enterprise Guide Interacts Directly with Microsoft Windows
         2. SAS Enterprise Guide Interacts with SAS
   3. Examples of Enhancing the Generated Code
   4. Examples of Writing Your Own Code
   5. Summary
5. 2. Understanding Coding with SAS Enterprise Guide
   1. Introduction
   2. The Structure of a SAS Program
      1. Writing Your Own Code: The Program Node
      2. Using and Customizing the Program Window
         1. Commenting Text
         2. Working with Large Programs
         3. Matching Brackets
         4. Abbreviations
         5. Macros
         6. Customization
      3. The Program Node in Process Flow Diagrams
   3. Understanding Generated Code
   4. Complementing the Generated Code
      1. Adding Code When a Server Is Used for the First Time
      2. Adding Code before or after a Task or Code
      3. Inserting Code into a Task
      4. Using Generated Code as a Template
   5. Summary
   6. Exercises
6. 3. Getting Started
   1. Introduction
   2. Getting Ready to Face the World
      1. We Know Where You Live
      2. Formats and Functions
      3. A Final Word on Options
   3. Query-Free Filtering
   4. Do It Once—Use It Often
      1. Using Macro Variables
      2. Using Macro Functions
         1. Improving the WHERE Clause
         2. Executing SAS Functions
         3. Some Other Macro Functions
   5. ODS: The Output Delivery System
      1. What Is ODS All About?
      2. Making Your Output Go Where You Want
   6. Summary
   7. Exercises
7. 4. Data Manipulation Part 1: Queries
   1. Introduction
   2. What Is SQL?
   3. Basic Queries: What SAS Enterprise Guide Does Already
      1. The Query Builder Task
      2. The Delete Data Sets and Formats Task
      3. The Append Data Task
   4. Indexes: Creation and Usage
      1. Index Creation
      2. Index Usage
      3. Good Index, Bad Index
   5. Updating and Validating Data
      1. Deleting Rows
      2. Inserting Rows
      3. Updating
      4. Integrity Checks
   6. Advanced SQL Queries
   7. Summary
   8. Where to Look for More Information
   9. Exercises
8. 5. Data Manipulation Part 2: DATA Step and Functions
   1. Introduction
   2. DATA Step Basics
   3. Creating Multiple Tables
   4. When Position Matters
   5. SAS Functions
   6. Summary
   7. Where to Look for More Information
   8. Exercises
9. 6. Seeing Data Differently
   1. Introduction
   2. Basic Formats: The Create Formats Task
   3. Reviewing Existing Formats
   4. Creating Picture Formats
      1. Formatting Numbers
      2. Formatting Dates and Times
   5. Multilabel Formats
   6. Linking Formats
   7. Using Formats as Look-up Tables
   8. Creating Informats
   9. Summary
   10. Where to Look for More Information
   11. Exercises
10. 7. Enhancing Report Output
    1. Introduction
    2. More ODS
    3. Improving Titles
       1. Improving BY Lines
       2. Page Numbers
       3. Basic Formatting
    4. Adding Hyperlinks
    5. One-Stop Reporting
       1. Hyperlinks Revisited
    6. Trafficlighting
    7. Varying Output
    8. Alternative Output Destinations
    9. Summary
    10. Where to Look for More Information
    11. Exercises
11. 8. Graphical Output
    1. Introduction
    2. SAS Enterprise Guide Graphical Output
    3. Enhancing SAS Enterprise Guide Graphs
       1. More Linking
       2. Exploding Pies
       3. Detail Pies
    4. Extra SAS Graphical Output
    5. Summary
    6. Where to Look for More Information
    7. Exercises
12. 9. Macros: Reusable Programming
    1. Introduction
    2. What Is a Macro?
    3. Converting a Program to a Macro
    4. Converting a Task to a Macro
    5. Complex Prompts
    6. Choosing Your Path
    7. Including Macros
    8. The Biggest Exploding Pie
    9. Summary
    10. Where to Look for More Information
    11. Exercises
13. A. Directory of Procedures Supported by SAS Enterprise Guide
    1. Directory of Procedures
    2. Task Cross-Reference
    3. Category Cross-Reference
14. B. Selected Additional SAS Procedures
15. C. Data Used in This Book
    1. CLASS
    2. James Bond Data
    3. Zone Access Data
    4. Software Retail Data
16. D. Solutions to Exercises