O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SAS Programming for Enterprise Guide Users, Second Edition

Book Description

New and updated for SAS Enterprise Guide 4.2! In this pragmatic, example-driven book, author Neil Constable demonstrates how you can use SAS code to enhance the capabilities of SAS Enterprise Guide. Designed to help you gain extra value from the products you already have, SAS Programming for Enterprise Guide Users contains tips and techniques that show you a variety of features that cannot be accessed directly through the task interfaces. In all cases, techniques are shown with examples that you can try and test, plus additional exercises are included to give you more practice. The end result is more efficient and resilient use of SAS Enterprise Guide in a wider variety of business areas. Included is a discussion of the following subject areas: the Output Delivery System, advanced formatting, macro variables and macros, advanced reporting using PROC REPORT, highlighting in reports, hyperlinking between reports and graphs, data manipulation using SQL, data manipulation using the DATA step, extended graphics. By adding small amounts of code in key areas, SAS Enterprise Guide users can get more out of the product than the tasks reveal. Users should be familiar with the SAS Enterprise Guide user interface and tasks. No programming experience is necessary. This book is part of the SAS Press program.

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