Carpenter's Complete Guide to the SAS REPORT Procedure


Book Description

Art Carpenter demystifies the powerful REPORT procedure and shows you how to incorporate this highly flexible and customizable procedure into your SAS reporting programs. Combining his years of SAS experience with a talent for instruction, Art offers clear and comprehensive coverage that demonstrates how valuable this procedure is for both summarizing and displaying data. Illustrated with more than two hundred examples and sample exercises to reinforce your learning, Carpenter's Complete Guide to the SAS REPORT Procedure provides you with information that you can put to immediate use. The text is divided into three distinct sections. Part 1 introduces you to PROC REPORT, showing you how it works and "thinks." This section is designed to be read linearly by users who are unfamiliar with the procedure. Part 2 is a collection of increasingly more complex examples that feature advanced options and capabilities. It also introduces the relationship between PROC REPORT and the Output Delivery System (ODS). Part 3 incorporates the options and statements described in Parts 1 and 2 into a series of examples that highlight many of the extended capabilities of PROC REPORT. Included in this section is a discussion of a few ODS statements and options that might be useful to a PROC REPORT programmer, plus an in-depth look at the PROC REPORT process itself, especially as it relates to the execution of compute blocks. Art's author page at support.sas.com/carpenter includes the following bonus material: example SAS data sets, example results, and a compilation of nearly 100 related conference papers. This book is part of the SAS Press program.




Carpenter's Complete Guide to the SAS Macro Language, Third Edition


Book Description

Providing both a compendium of reusable and adaptable code, and opportunities for deepening your understanding and growing as a SAS programmer, this pragmatic, example-driven reference offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more. --




Carpenter's Guide to Innovative SAS Techniques


Book Description

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.




The SAS Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques


Book Description

Whether you work in banking/finance, pharmaceuticals, the health and life sciences, or government, this unique book is intended for programmers of all skill levels and will help you harness all the power and capability of PROC REPORT. --




Validating Clinical Trial Data Reporting with SAS


Book Description

This indispensable guide focuses on validating programs written to support the clinical trial process from after the data collection stage to generating reports and submitting data and output to the Food and Drug Administration.




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.




SAS Programming for Enterprise Guide Users, Second Edition


Book Description

New and updated for SAS Enterprise Guide 4.2! In this pragmatic, example-driven book, author Neil Constable demonstrates how you can use SAS code to enhance the capabilities of SAS Enterprise Guide. Designed to help you gain extra value from the products you already have, SAS Programming for Enterprise Guide Users contains tips and techniques that show you a variety of features that cannot be accessed directly through the task interfaces. In all cases, techniques are shown with examples that you can try and test, plus additional exercises are included to give you more practice. The end result is more efficient and resilient use of SAS Enterprise Guide in a wider variety of business areas. Included is a discussion of the following subject areas: the Output Delivery System, advanced formatting, macro variables and macros, advanced reporting using PROC REPORT, highlighting in reports, hyperlinking between reports and graphs, data manipulation using SQL, data manipulation using the DATA step, extended graphics. By adding small amounts of code in key areas, SAS Enterprise Guide users can get more out of the product than the tasks reveal. Users should be familiar with the SAS Enterprise Guide user interface and tasks. No programming experience is necessary. This book is part of the SAS Press program.




Data Management Solutions Using SAS Hash Table Operations


Book Description

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!




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.




An Introduction to SAS University Edition


Book Description

Aimed at beginners who have downloaded the free SAS University Edition and want to either use the point-and-click interactive environment of SAS Studio, or who want to write their own SAS programs, or both, this book begins by showing you how to obtain the SAS University Edition, and how you can run SAS on a PC or Macintosh computer. Topics include: performing basic tasks, such as producing a report, summarizing data, producing charts and graphs, and using the SAS Studio built-in tasks; performing basic statistical tests using the interactive point-and-click environment; how to write your own SAS programs, and how to use SAS procedures to perform a variety of tasks; how to read data from a variety of sources: text files, Excel workbooks, and CSV files. In order to get familiar with the SAS Studio environment, this book also shows you how to access dozens of interesting data sets that are included with the product. --