SAS Hash Object Programming Made Easy

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1612900984
Format: PDF
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.

SAS Hash Object Programming Made Easy

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1629590282
Format: PDF, Mobi
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. Shows readers how to use these powerful features, which they can program to quickly look up and manage data and to conserve computing resources.

Data Management Solutions Using SAS Hash Table Operations

Author: Paul Dorfman
Publisher: SAS Institute
ISBN: 1635260590
Format: PDF, Docs
Download Now
Hash tables can do a lot more than you might think! Data Management Solutions Using SAS Hash Table Operations: A Business Intelligence Case Study concentrates on solving your challenging data management and analysis problems via the power of the SAS hash object, whose environment and tools make it possible to create complete dynamic solutions. To this end, this book provides an in-depth overview of the hash table as an in-memory database with the CRUD (Create, Retrieve, Update, Delete) cycle rendered by the hash object tools. By using this concept and focusing on real-world problems exemplified by sports data sets and statistics, this book seeks to help you take advantage of the hash object productively, in particular, but not limited to, the following tasks: select proper hash tools to perform hash table operations use proper hash table operations to support specific data management tasks use the dynamic, run-time nature of hash object programming understand the algorithmic principles behind hash table data look-up, retrieval, and aggregation learn how to perform data aggregation, for which the hash object is exceptionally well suited manage the hash table memory footprint, especially when processing big data use hash object techniques for other data processing tasks, such as filtering, combining, splitting, sorting, and unduplicating. Using this book, you will be able to answer your toughest questions quickly and in the most efficient way possible!

SAS Macro Programming Made Easy Third Edition

Author: Michele M. Burlew
Publisher: SAS Institute
ISBN: 1629591513
Format: PDF, ePub, Mobi
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.

The DS2 Procedure SAS Programming Methods at Work

Author: Peter Eberhardt
Publisher: SAS Institute
ISBN: 1629602221
Format: PDF, Mobi
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 9 3 Component Objects

Author: SAS Institute
Publisher: SAS Institute
ISBN: 1607649527
Format: PDF, ePub
Download Now
Annotation Provides comprehensive information about the Base SAS component objects, which include the hash, hash iterator, and Java objects.

Carpenter s Guide to Innovative SAS Techniques

Author: Art Carpenter
Publisher: SAS Institute
ISBN: 1612902022
Format: PDF
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.

Output Delivery System

Author: Lauren E. Haworth
Publisher: SAS Institute
ISBN: 1607643839
Format: PDF, ePub
Download Now
Incorporating broad coverage of the best ODS features in one book, Output Delivery System: The Basics and Beyond goes beyond Lauren Haworth's original ODS text to demonstrate the many new and enhanced features of ODS and SAS 9.2. With SAS 9.2, ODS provides a myriad of choices for reporting and displaying analytical results with a greater variety of formatting selections and output destinations. As experienced SAS users, Lauren E. Haworth, Cynthia L. Zender, and Michele M. Burlew know how important it is to be able to produce customized output in different formats to meet the needs of clients. Geared toward all levels of SAS users, Output Delivery System: The Basics and Beyond is an example-driven book that presents each of the wide array of ODS techniques in an easy-to-use, two-page layout, with the text and code on one page and the resulting output on the facing page. The book begins with basic syntax and progresses to more complex techniques and custom styles. You will learn to take basic SAS output and transform it into an HTML page, a word-processor-friendly RTF file, or printer-friendly PDF output. You'll learn how to generate a table of contents page for RTF and PDF files, generate bookmarks for PDF files, and generate custom page numbering for those destinations. You will also learn the basic concepts of changing style templates, using table templates with the DATA step, and using tagset templates to generate custom markup language tags and output. Other new features of ODS are also discussed, such as the ODS Graphics Framework and the new ODS Statistical Graphics procedures.

PROC SQL Beyond the Basics Using SAS Second Edition

Author: Kirk Paul Lafler
Publisher: SAS Institute
ISBN: 1612907342
Format: PDF, ePub
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.

Sharpening Your Advanced SAS Skills

Author: Sunil Gupta
Publisher: CRC Press
ISBN: 1498766900
Format: PDF, Kindle
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.