Mark Jordan

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.

Create an account