PROC TABULATE by Example


Book Description

An abundance of real-world examples highlights Lauren Haworth's PROC TABULATE by Example. Beginning and intermediate SAS users will find this step-by-step guide to producing tables and reports using the TABULATE procedure both convenient and inviting. Applications are presented in a self-contained, two-page layout; discussion material and sample code are on one page, and the resulting tables are on the facing page. Topics are presented in order of increasing complexity, making this an excellent training manual or self-tutorial. The concise format also makes this a quick reference guide for specific applications for more advanced users. A very handy section on common problems and their solutions is also included. With this book, you will quickly learn how to generate tables using macros, create tables using SAS/ASSIST software, present output on the Internet, handle percentages and missing data, modify row and column headings, and produce one-, two-, and three-dimensional tables using PROC TABULATE. Also provided are more advanced tips on complex formatting and exporting PROC TABULATE to other applications.




Learning SAS by Example


Book Description

Learn to program SAS by example! Learning SAS by Example, A Programmer’s Guide, Second Edition, teaches SAS programming from very basic concepts to more advanced topics. Because most programmers prefer examples rather than reference-type syntax, this book uses short examples to explain each topic. The second edition has brought this classic book on SAS programming up to the latest SAS version, with new chapters that cover topics such as PROC SGPLOT and Perl regular expressions. This book belongs on the shelf (or e-book reader) of anyone who programs in SAS, from those with little programming experience who want to learn SAS to intermediate and even advanced SAS programmers who want to learn new techniques or identify new ways to accomplish existing tasks. In an instructive and conversational tone, author Ron Cody clearly explains each programming technique and then illustrates it with one or more real-life examples, followed by a detailed description of how the program works. The text is divided into four major sections: Getting Started, DATA Step Processing, Presenting and Summarizing Your Data, and Advanced Topics. Subjects addressed include Reading data from external sources Learning details of DATA step programming Subsetting and combining SAS data sets Understanding SAS functions and working with arrays Creating reports with PROC REPORT and PROC TABULATE Getting started with the SAS macro language Leveraging PROC SQL Generating high-quality graphics Using advanced features of user-defined formats and informats Restructuring SAS data sets Working with multiple observations per subject Getting started with Perl regular expressions You can test your knowledge and hone your skills by solving the problems at the end of each chapter.




The Power of PROC Format


Book Description

Programmers, statisticians, or data analysts can learn how to make the powerful PROC FORMAT procedure work for them with this guide. Written in an easy-to-follow tutorial style and illustrated with real-world examples and solutions, this handy guide introduces beginning to intermediate SAS users to the functionality of the FORMAT procedure.




PROC REPORT by Example


Book Description

PROC REPORT by Example: Techniques for Building Professional Reports Using SAS provides real-world examples using PROC REPORT to create a wide variety of professional reports. Written from the point of view of the programmer who produces the reports, this book explains and illustrates creative techniques used to achieve the desired results. Each chapter focuses on a different concrete example, shows an image of the final report, and then takes you through the process of creating that report. You will be able to break each report down to find out how it was produced, including any data manipulation you have to do. The book clarifies solutions to common, everyday programming challenges and typical daily tasks that programmers encounter. For example: obtaining desired report formats using style templates supplied by SAS and PROC TEMPLATE, PROC REPORT STYLE options, and COMPUTE block features employing different usage options (DISPLAY, ORDER, GROUP, ANALYSIS, COMPUTED) to create a variety of detail and summary reports using BREAK statements and COMPUTE blocks to summarize and report key findings producing reports in various Output Delivery System (ODS) destinations including RTF, PDF, XML, TAGSETS.RTF embedding images in a report and combining graphical and tabular data with SAS 9.2 and beyond Applicable to SAS users from all disciplines, the real-life scenarios will help elevate your reporting skills learned from other books to the next level. With PROC REPORT by Example: Techniques for Building Professional Reports Using SAS, what seemed complex will become a matter of practice. This book is part of the SAS Press program.




Output Delivery System


Book Description

Incorporating broad coverage of the best ODS features in one book, this work goes beyond Haworth's original ODS text to demonstrate the many new and enhanced features of ODS and SAS 9.2. It presents each of the wide array of ODS techniques in an easy-to-use, two-page layout.




SAS Guide to Report Writing


Book Description

Using a wealth of easy-to-follow examples, this timesaving book demonstrates the many different styles of reports that are available and the SAS tools used to generate them. Examples enable more experienced programmers to quickly grasp new techniques, while margin notes and additional discussions provide novice users with the details they need for effective learning.




PROC DOCUMENT by Example Using SAS


Book Description

PROC DOCUMENT by Example Using SAS demonstrates the practical uses of the DOCUMENT procedure, a part of the Output Delivery System, in SAS 9.3. Michael Tuchman explains how to work with PROC DOCUMENT, which is designed to store your SAS procedure output for replay at a later time without having to rerun your original SAS code. You’ll learn how to: save a collection of procedure output, descriptive text, and supporting graphs that can be replayed as a single unit save output once and distribute that same output in a variety of ODS formats such as HTML, CSV, and PDF create custom reports by comparing output from the same procedure run at different points in time create a table of contents for your output modify the appearance of both textual and graphical ODS output even if the original data is no longer available or easily accessible manage your tabular and graphical output by using descriptive labels, titles, and footnotes rearrange the original order of output in a procedure to suit your needs After using this book, you’ll be able to quickly and easily create libraries of professional-looking output that are accessible at any time. This book is part of the SAS Press program.




The Little SAS Book


Book Description

A classic that just keeps getting better, The Little SAS Book is essential for anyone learning SAS programming. Lora Delwiche and Susan Slaughter offer a user-friendly approach so that readers can quickly and easily learn the most commonly used features of the SAS language. Each topic is presented in a self-contained, two-page layout complete with examples and graphics. Nearly every section has been revised to ensure that the sixth edition is fully up-to-date. This edition is also interface-independent, written for all SAS programmers whether they use SAS Studio, SAS Enterprise Guide, or the SAS windowing environment. New sections have been added covering PROC SQL, iterative DO loops, DO WHILE and DO UNTIL statements, %DO statements, using variable names with special characters, the ODS EXCEL destination, and the XLSX LIBNAME engine. This title belongs on every SAS programmer's bookshelf. It's a resource not just to get you started, but one you will return to as you continue to improve your programming skills. Learn more about the updates to The Little SAS Book, Sixth Edition here. Reviews for The Little SAS Book, Sixth Edition can be read here.




Cody's Data Cleaning Techniques Using SAS, Third Edition


Book Description

Written in Ron Cody's signature informal, tutorial style, this book develops and demonstrates data cleaning programs and macros that you can use as written or modify which will make your job of data cleaning easier, faster, and more efficient. --




PROC SQL by Example


Book Description

In PROC SQL by Example: Using SQL within SAS, author Howard Schreier illustrates the use of PROC SQL in the context of the SAS DATA step and other SAS procedures (such as SORT, FREQ, MEANS, SUMMARY, APPEND, DATASETS, and TRANSPOSE) whose functionality overlaps and complements that of SQL. Using a side-by-side approach, this concise reference guide includes many extensively explained examples showing equivalent DATA step and SQL code, enabling SAS users to take advantage of existing SAS skills and knowledge while learning about SQL. Discussions cover the differences between SQL and the DATA step as well as situations where SQL and the DATA step are used together to benefit from the strengths of each. Topics addressed include working with joins and merges; using subqueries; understanding set operators; using the Macro Facility with PROC SQL; maintaining tables; working with views; using PROC SQL as a report generator; and more. This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL. This book is part of the SAS Press program.