book

Mastering the SAS DS2 Procedure

by Mark Jordan

May 2016

Intermediate to advanced

150 pages

3h 30m

English

SAS Institute

Read now

Unlock full access

1.1 Introduction1.1.1 What to Expect from This Book1.1.2 Prerequisite Knowledge1.2 Accessing SAS and Setting Up for Practice1.2.1 Getting Ready to Practice
2.1 Introduction2.2 DS2 Programming Basics2.2.1 General Considerations2.2.2 Program Structure2.2.3 Program Blocks2.2.4 Methods2.2.5 System 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.4 Review of Key Concepts
3.1 Introduction3.2 DS2 Data Programs versus Base SAS DATA Steps3.2.1 General Considerations3.2.2 The “Six Subtle Dissimilarities”3.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.3.3 Object-Oriented Programming with DS2 Packages4.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 SQLSTMT Package5.6.1 General5.6.2 SQLSTMT Package Example5.7 The TZ (Time Zone) Package5.7.1 General5.7.2 TZ Package Example5.8 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 Running DS2 Programs In-Database6.5 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 Trouble-Shooting 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

About The Author

A self-avowed technophile, Mark Jordan grew up in northeast Brazil as the son of Baptist missionaries. He served 20 years as a US Navy submariner, pursuing his passion for programming as a hobby. Upon retiring from the Navy, he turned his hobby into a dream job, working as a SAS programmer for 9 years in manufacturing and financial services before coming to SAS Institute in 2003. Mark teaches a broad spectrum of Foundation SAS programming classes, and has authored and co-authored the several SAS training courses.

When he isn’t teaching SAS programming, Mark sporadically posts “Jedi SAS Tricks” on the SAS Training Post blog, enjoys ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Publisher Resources

ISBN: 9781629603070

Mastering the SAS DS2 Procedure

by Mark Jordan

About The Author

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like