SAS Hash Object Programming Made Easy

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1612900984
Format: PDF, ePub
Download Now
Hash objects, an efficient look-up tool in the SAS DATA step, are object-oriented programming structures that function differently from traditional SAS language statements. Michele Burlew's SAS Hash Object Programming Made Easy shows readers how to use these powerful features, which they can program to quickly look up and manage data and to conserve computing resources. SAS provides various look-up techniques, and hash objects are among the newest, so therefore many users may not have yet used them. Because the examples presented vary in complexity, SAS Hash Object Programming Made Easy is useful to SAS users of all experience levels, from novice programmer to advanced programmer. Novice programmers can adapt some of the simpler hash programming techniques as they develop their SAS programming skills. This book helps more experienced programmers learn how to take advantage of hash object programming by comparing traditional processing techniques to those that use hash objects. Additionally, users from diverse fields with different requirements can adapt the examples in SAS Hash Object Programming Made Easy to fit their unique situations. This book is part of the SAS Press program.

The DS2 Procedure SAS Programming Methods at Work

Author: Peter Eberhardt
Publisher: SAS Institute
ISBN: 1629602221
Format: PDF, Kindle
Download Now
The issue facing most SAS programmers today is not that data space has become bigger ("Big Data" ), but that our programming problem space has become bigger. Through the power of DS2, this book shows programmers how easily they can manage complex problems using modular coding techniques. The DS2 Procedure: SAS Programming Methods at Work outlines the basic structure of a DS2 program and teaches you how each component can help you address problems. The DS2 programming language in SAS 9.4 simplifies and speeds data preparation with user-defined methods, storing methods and attributes in shareable packages, and threaded execution on multicore symmetric multiprocessing (SMP) and massively parallel processing (MPP) machines. This book is intended for all BASE SAS programmers looking to learn about DS2; readers need only an introductory level of SAS to get started. Topics covered include introductions to Object Oriented Programming methods, DATA step programs, user-defined methods, predefined packages, and threaded processing.

SAS Macro Programming Made Easy Third Edition

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1629591513
Format: PDF
Download Now
This book provides beginners with a thorough foundation in SAS macro programming. The macro facility is a popular part of SAS. Macro programming is a required skill for many SAS programming jobs, and the SAS Advanced Programming Certification Exam tests macro processing concepts. Whether you're looking to become certified, land a job, or increase your skills, you'll benefit from SAS Macro Programming Made Easy, Third Edition. By following Michele Burlew's examples and step-by-step instructions, you'll be able to rapidly perform repetitive programming tasks, to pass information between programming steps more easily, and to make your programming easier to read. Updated for SAS 9.4, this book teaches you the elements of the macro facility (macro variables, macro programs, macro language), how to write a macro program, techniques for macro programming, tips on using the macro facility, how the macro facility fits into SAS, and about the interfaces between the macro facility and other components of SAS. Beginning macro programmers will learn to write SAS macro programs quickly and efficiently. More experienced programmers will find this book useful to refresh their conceptual knowledge and expand on their macro programming skills. Ultimately, any user interested in automating their programs—including analysts, programmers, and report writers—will find Michele Burlew's book an excellent tutorial. This book is part of the SAS Press program.

PROC SQL Beyond the Basics Using SAS Second Edition

Author: Kirk Paul Lafler
Publisher: SAS Institute
ISBN: 1612907342
Format: PDF
Download Now
Kirk Lafler's PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful "Summary" that precede each chapter to look for help on a specific topic. The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language using discussion and numerous real-world examples. This book is part of the SAS Press program.

Cody s Collection of Popular SAS Programming Tasks and How to Tackle Them

Author: Ron Cody
Publisher: SAS Institute
ISBN: 1629597767
Format: PDF, ePub
Download Now
Cody's Collection of Popular SAS Programming Tasks and How to Tackle Them presents often-used programming tasks that readers can either use as presented or modify to fit their own programs, all in one handy volume. Esteemed author and SAS expert Ron Cody covers such topics as character to numeric conversion, automatic detection of numeric errors, combining summary data with detail data, restructuring a data set, grouping values using several innovative methods, performing an operation on all character or all numeric variables in a SAS data set, and much more! SAS users of all levels interested in improving their programming skills will benefit from this easy-to-follow collection of tasks. This book is part of the SAS Press program.

Mastering the SAS DS2 Procedure

Author: Mark Jordan
Publisher: SAS Institute
ISBN: 1635266068
Format: PDF, Mobi
Download Now
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.

Combining and Modifying SAS Data Sets

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1607643707
Format: PDF, ePub, Docs
Download Now
Completely updated for SAS 9.2, this guide presents examples that show solutions to common programming tasks that involve combining, modifying, and reshaping data sets. Designed for SAS programmers at all levels.

Carpenter s Guide to Innovative SAS Techniques

Author: Art Carpenter
Publisher: SAS Institute
ISBN: 1612902022
Format: PDF, ePub, Docs
Download Now
Carpenter's Guide to Innovative SAS Techniques offers advanced SAS programmers an all-in-one programming reference that includes advanced topics not easily found outside the depths of SAS documentation or more advanced training classes. Art Carpenter has written fifteen chapters of advanced tips and techniques, including topics on data summary, data analysis, and data reporting. Special emphasis is placed on DATA step techniques that solve complex data problems. There are numerous examples that illustrate advanced techniques that take advantage of formats, interface with the macro language, and utilize the Output Delivery System. Additional topics include operating system interfaces, table lookup techniques, and the creation of customized reports.

Practical Time Series Analysis Using SAS

Author: Anders Milhoj
Publisher: SAS Institute
ISBN: 1612901700
Format: PDF, Docs
Download Now
Anders Milhøj's Practical Time Series Analysis Using SAS explains and demonstrates through examples how you can use SAS for time series analysis. It offers modern procedures for forecasting, seasonal adjustments, and decomposition of time series that can be used without involved statistical reasoning. The book teaches, with numerous examples, how to apply these procedures with very simple coding. In addition, it also gives the statistical background for interested readers. Beginning with an introductory chapter that covers the practical handling of time series data in SAS using the TIMESERIES and EXPAND procedures, it goes on to explain forecasting, which is found in the ESM procedure; seasonal adjustment, including trading-day correction using PROC X12; and unobserved component models using the UCM procedure.SAS Products and Releases: Base SAS: 9.3 SAS/STAT: 9.3 Operating Systems: Windows

Sharpening Your Advanced SAS Skills

Author: Sunil Gupta
Publisher: CRC Press
ISBN: 1498766900
Format: PDF
Download Now
Sharpening Your Advanced SAS® Skills presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. Drawing on his more than 20 years’ experience of SAS programming in the pharmaceutical industry, the author provides a unique approach that empowers both advanced programmers who need a quick refresher and programmers interested in learning new techniques. The book helps you easily search for key points by summarizing and differentiating the syntax between similar SAS statements and options. Each chapter begins with an overview so you can quickly locate the detailed examples and syntax. The basic syntax, expected data, and descriptions are organized in summary tables to facilitate better memory recall. General rules list common points about similar statements or options. Real-world examples of SAS programs and code statements are line numbered with references, such as SAS papers and websites, for more detailed explanations. The text also includes end-of-chapter questions to reinforce your knowledge of the topics and prepare you for the advanced SAS certification exam. In addition, the author’s website offers mindmaps and process flowcharts that connect concepts and relationships.