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

Dedication

To Ron Cody, SAS guru and author extraordinaire—your advice and encouragement finally made me believe I could do it.

To the amazing folks at SAS Press who were always there when I needed them. Without your constant and cheerful support, this book would have never been written.

To Lori, my love—without your love and encouragement, I’d have given up hope! Thanks for keeping the faith and urging me on.

And finally, to Tiger Man, the world’s friendliest cat—your enthusiasm and snuggling abilities are legend, but your typing skills could still use improvement...