Mastering the SAS DS2 Procedure: Advanced Data-Wrangling Techniques, Second Edition (Hardcover edition)

by Mark Jordan

Overview

Enhance your SAS data-wrangling skills with high-precision and parallel data manipulation using the DS2 programming language.

Now in its second edition, this book addresses the DS2 programming language from SAS, which combines the precise procedural power and control of the Base SAS DATA step language with the simplicity and flexibility of SQL. DS2 provides simple, safe syntax for performing complex data transformations in parallel and enables manipulation of native database data types at full precision. It also covers PROC FEDSQL, a modernized SQL language that blends perfectly with DS2. You will learn to harness the power of parallel processing to speed up CPU-intensive computing processes in Base SAS and how to achieve even more speed by processing DS2 programs on massively parallel database systems. Techniques for leveraging internet APIs to acquire data, avoiding large data movements when working with data from disparate sources, and leveraging DS2's new data types for full-precision numeric calculations are presented, with examples of why these techniques are essential for the modern data wrangler.

Here's what's new in this edition:

• how to significantly improve performance by using the new SAS Viya architecture with its SAS Cloud Analytic Services (CAS)

• how to declare private variables and methods in a package

• the new PROC DSTODS2

• the PCRXFIND and PCRXREPLACE packages

While working though the code samples provided with this book, you will build a library of custom, reusable, and easily shareable DS2 program modules, execute parallelized DATA step programs to speed up a CPU-intensive process, and conduct advanced data transformations using hash objects and matrix math operations.

This book is part of the SAS Press Series.

Product Details

ISBN-13:	9781635266061
Publisher:	SAS Institute
Publication date:	03/23/2018
Sold by:	Barnes & Noble
Format:	eBook
Pages:	192
File size:	28 MB
Note:	This product may take a few minutes to download.

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 playing with his grandchildren and great-grandchildren, hanging out at the beach and reading science fiction novels. His secret obsession is flying toys – kites, rockets, drones – though he tries (unsuccessfully) to convince his wife they are for the grandkids. Mark currently lives in Toano, VA with his wife, Lori, and their cat, the amazing Tiger Man. You can read his blog at http://go.sas.com/jedi and follow him on Twitter @SASJedi.