book

Mastering the SAS DS2 Procedure

by Mark Jordan

March 2018

Intermediate to advanced

192 pages

4h 33m

English

SAS Institute

Read now

Unlock full access

1.1 Introduction1.1.1 What is DS2?1.1.2 Traditional SAS DATA Step versus DS21.1.3 What to Expect from This Book1.1.4 Prerequisite Knowledge1.2 Accessing SAS and Setting Up for Practice
2.1 Introduction2.2 DS2 Programming Basics2.2.1 General Considerations2.2.2 Program Structure2.2.3 Procedure Options and Global Statements2.2.4 Program Blocks2.2.5 Methods2.2.6 User-Defined Methods2.2.7 Variable Identifiers and Scope2.2.8 Data Program Execution2.3 Converting a SAS DATA Step to a DS2 Data Program2.3.1 A Traditional SAS DATA Step2.3.2 Considerations2.3.3 The Equivalent DS2 Data Program2.3.4 More Complex Data Program Processing2.3.5 Automatic Conversion with PROC DSTODS22.4 Review of Key Concepts
3.1 Introduction3.2 DS2 Data Programs versus Base SAS DATA Steps3.2.1 General Considerations3.2.2 The Seven Subtle Dissimilarities3.2.3 DS2 “Missing„ Features3.3 Data Types in DS23.3.1 DS2 and ANSI Data Types3.3.2 Automatic Data Type Conversion3.3.3 Non-coercible Data Types3.3.4 Processing SAS Missing and ANSI Null Values3.4 Review of Key Concepts
4.1 Introduction4.2 Diving into User-Defined Methods4.2.1 Overview4.2.2 Designing a User-Defined Method4.3 User-Defined Packages4.3.1 General Considerations4.3.2 User-Defined Package Specifics4.4 Object-Oriented Programming with DS2 Packages4.4.1 General Considerations4.4.2 Designing an Object4.4.3 Using Objects as Building Blocks4.4 Review of Key Concepts
5.1 Introduction5.2 Executing FCMP Functions in DS25.2.1 The FCMP Package5.2.2 FCMP Package Example5.3 The Hash and Hiter (Hash Iterator) Packages5.3.1 General5.3.2 Hash Package Example5.3.3 Hash Iterator Package Example5.4 The HTTP and JSON Packages5.4.1 General5.4.2 HTTP Package Specifics5.4.3 JSON Package Specifics5.4.4 HTTP and JSON Packages Example5.5 The Matrix Package5.5.1 General5.5.2 Matrix Package Example5.6 The PCRXFIND and PCRXREPLACE Packages5.6.1 General5.6.2 PCRXFIND and PCRXREPLACE Package Examples5.7 The SQLSTMT Package5.7.1 General5.7.2 SQLSTMT Package Example5.8 The TZ (Time Zone) Package5.8.1 General5.8.2 TZ Package Example5.9 Review of Key Concepts
6.1 Introduction6.2 Understanding Threaded Processing6.2.1 The Need for Speed6.2.2 Loading Data to and from RAM6.2.3 Manipulating Data in RAM6.3 DS2 Thread Programs6.3.1 Writing DS2 Thread Programs6.3.2 Parallel Processing Data with DS2 Threads6.4 DS2 and the SAS In-Database Code Accelerator6.4.1 DS2 Program In-Database Processing6.5 DS2 and SAS® Viya® and SAS Cloud Analytic Services (CAS)6.5.1 A Brief Introduction to SAS Viya and CAS6.5.2 Running DS2 Programs in CAS6.6 Review of Key Concepts

7.1 Introduction7.2 DS2_OPTIONS Statement7.2.1 TRACE Option7.3 Analyzing Performance with the SAS Log7.3.1 Obtaining Performance Statistics7.3.2 Analyzing Performance Statistics7.3.3 Tuning Your Code7.4 Learning and Troubleshooting Resources7.4.1 SAS Learning Resources7.4.2 SAS Support Communities7.4.3 SAS Technical Support7.5 Review of Key Concepts7.6 Connecting with the Author

Content preview from Mastering the SAS DS2 Procedure

Foreword

In my many years of managing the development of some of the core data manipulation languages of SAS, such as the DATA step, DS2, PROC SQL, and FedSQL, I have come to appreciate the value of education. It doesn’t matter how good the technology is if it is not understood by the people it is intended to benefit. And simply collecting the facts into a volume is not the same as teaching a subject.

With his new book, Mastering the SAS DS2 Procedure: Advanced Data-Wrangling Techniques, Second Edition, Mark has succeeded in providing an extremely concise introduction to not only the syntax of the SAS DS2 language but, more importantly, to the objectives of the language. He builds his examples systematically in a way that keeps readers turning ...