Book description
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.
Table of contents
- Praise from the Experts
- Copyright
- Foreword
- Acknowledgments
- 1. Why Do I Need to Write Code?
- 2. Understanding Coding with SAS Enterprise Guide
- 3. Getting Started
-
4. Data Manipulation Part 1: Queries
- 4.1. Introduction
- 4.2. What Is SQL?
- 4.3. Basic Queries: What SAS Enterprise Guide Does Already
- 4.4. The Filter and Query Task
- 4.5. The Delete Data Sets and Formats Task
- 4.6. The Append Data Task
- 4.7. Indexes: Creation and Usage
- 4.8. Index Creation
- 4.9. Index Usage
- 4.10. Updating and Validating Data
- 4.11. Inserting Rows
- 4.12. Updating
- 4.13. Integrity Checks
- 4.14. Advanced SQL Queries
- 4.15. Summary
- 4.16. Where to Look for More Information
- 4.17. Exercises
- 5. Data Manipulation Part 2: DATA Step and Functions
- 6. Seeing Data Differently
- 7. Enhancing Report Output
- 8. Graphical Output
- 9. Macros: Reusable Programming
- A. Directory of Procedures Supported by SAS Enterprise Guide
- B. Selected Additional SAS Procedures
- C. Data Used in This Book
- D. Solutions to Exercises
Product information
- Title: SAS® Programming for Enterprise Guide® Users
- Author(s):
- Release date: September 2007
- Publisher(s): SAS Institute
- ISBN: 9781599945408
You might also like
book
Test-Driven Machine Learning
Control your machine learning algorithms using test-driven development to achieve quantifiable milestones About This Book Build …
book
Hands-On Enterprise Automation with Python.
Invent your own Python scripts to automate your infrastructure About This Book Make the most of …
book
Mastering Hadoop 3
A comprehensive guide to mastering the most advanced Hadoop 3 concepts Key Features Get to grips …
book
Python Data Analysis Cookbook
Over 140 practical recipes to help you make sense of your data with ease and build …