Handbook of SAS® DATA Step Programming
Features
- Focuses on programming logic and algorithms, helping readers avoid common problems when creating SAS data sets
- Provides the prerequisite background for readers with minimal SAS knowledge
- Improves readers’ comprehension of essential SAS programming ideas, such as the compilation and execution phases of the DATA step and the PDV during DATA step execution
- Presents programming strategies that illustrate how to begin a programming task and the steps involved for solving the problem
- Offers data sets, programs, solutions to exercises, and slides demonstrating the PDV on the book’s CRC Press web page
Summary
To write an accomplished program in the DATA step of SAS®, programmers must understand programming logic and know how to implement and even create their own programming algorithm. Handbook of SAS® DATA Step Programming shows readers how best to manage and manipulate data by using the DATA step.
The book helps novices avoid common mistakes resulting from a lack of understanding fundamental and unique SAS programming concepts. It explains that learning syntax does not solve all problems; rather, a thorough comprehension of SAS processing is needed for successful programming. The author also guides readers through a programming task. In most of the examples, the author first presents strategies and steps for solving the problem, then offers a solution, and finally gives a more detailed explanation of the solution.
Understanding the DATA steps, particularly the program data vector (PDV), is critical to proper data manipulation and management in SAS. This book helps SAS programmers thoroughly grasp the concept of DATA step processing and write accurate programs in the DATA step. Numerous supporting materials, including data sets and programs used in the text, are available on the book’s CRC Press web page.
Table of Contents
Introduction to SAS
SAS Program and Language
Reading DATA into SAS
Creating and Modifying Variables
Base SAS Procedures
Subsetting Data by Selecting Variables
Changing the Appearance of Data
Creating Variables Conditionally
The IF-THEN/ELSE Statement
Executing One of Several Statements
Modifying the IF-THEN/ELSE Statement with the Assignment Statement
Understanding How the DATA Step Works
DATA Step Processing Overview
Retaining the Value of Newly Created Variables
Conditional Processing in the DATA Step
Debugging Techniques
BY-Group Processing in the DATA Step
Introduction to BY-Group Processing
Applications Utilizing BY-Group Processing
Writing Loops in the DATA Step
Implicit and Explicit Loops
Utilizing Loops to Create Samples
Using Looping to Read a List of External Files
Array Processing
Introduction to Array Processing
Functions and Operators Related to Array Processing
Some Array Applications
Applications That Use Multi-Dimensional Arrays
Combining Data Sets
Vertically Combining Data Sets
Horizontally Combining Data Sets
Data Input and Output
Introduction to Reading and Writing Text Files
Reading Text Files
Creating Text Files
Data Step Functions
Introduction to Functions and CALL Routines
Date and Time Functions
Character Variables
Functions for Converting Variable Types
Useful SAS Procedures
Using the SORT Procedure to Eliminate Duplicate Observations
Using the COMPARE Procedure to Compare the Contents of Two Data Sets
Restructuring Data Sets Using the TRANSPOSE Procedure
Creating the User-Defined Format Using the FORMAT Procedure
Using the OPTIONS Procedure to Modify SAS System Options
References
Exercises appear at the end of each chapter.
Author Bio(s)
Arthur Li is a biostatistician at the City of Hope National Medical Center in Los Angeles County, California. He is also a part-time statistical programming instructor at the University of Southern California, where he received an MS in biostatistics. He often gives presentations and seminars on DATA step programming and statistical analysis using SAS software at SAS conferences.
Downloads Updates
| Resource | OS Platform | Updated | Description | Instructions |
|---|---|---|---|---|
| K15213Web.zip | Cross Platform | October 12, 2012 | Additional Materials |
