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.

CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. • Create, customize, and change your pivot tables and pivot charts • Transform gigantic data sets into crystal-clear summary reports • Summarize and analyze data even faster with new Excel 2013 recommended pivot tables • Instantly highlight your most (and least) profitable customers, products, or regions • Quickly filter pivot tables using slicers • Use dynamic dashboards using Power View to see exactly where your business stands right now • Revamp analyses on the fly by simply dragging and dropping fields • Build dynamic self-service reporting systems your entire team can use • Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets • Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013

Have you ever used SAS Enterprise Guide and found yourself wishing that it had that one specific feature, something that you know would make it the perfect tool for your work or industry? You don't have to settle for just the "out of the box" features; you can add your own capabilities with SAS custom tasks!

Chris Hemedinger's new book takes you step-by-step through the process of creating custom tasks for use in SAS Enterprise Guide and SAS Add-In for Microsoft Office. Using standard off-the-shelf development tools for Microsoft .NET, you'll learn how you can hook in your custom processes and make them available to a wide range of SAS users. In the first part of the book, you'll learn how to use the development environment and the programming interfaces provided by SAS to create, test, and deploy new custom tasks. You'll learn about the services that the SAS Enterprise Guide framework offers, including data access, the ability to run SAS programs, and integration of your custom results into a SAS Enterprise Guide project.

In the second part of the book, Hemedinger provides a variety of useful, field-tested and ready-to-run examples—complete with C# and Visual Basic .NET source code. Each example highlights different programming techniques that you can apply immediately within your own custom tasks. The book also addresses important aspects of .NET programming, such as debugging, exception handling, threading models, and user interface design.

This book is part of the SAS Press program.

For decades researchers and programmers have used SAS to analyze, summarize, and report clinical trial data. Now Chris Holland and Jack Shostak have written the first comprehensive book on applying clinical research data and metadata to the Clinical Data Interchange Standards Consortium (CDISC) standards.

Implementing CDISC Using SAS: An End-to-End Guide is an all-inclusive guide on how to implement and analyze Study Data Tabulation Model (SDTM) and Analysis Data Model (ADaM) data and prepare clinical trial data for regulatory submissions. Topics covered include creating and using metadata, developing conversion specifications, implementing and validating SDTM and ADaM data, determining solutions for legacy data conversions, and preparing data for regulatory submission. The book covers products such as Base SAS, SAS Clinical Data Integration, and the SAS Clinical Standards Toolkit, as well as JMP Clinical.

Anyone dealing with CDISC standards--including SAS or JMP programmers, statisticians, and data managers in the pharmaceutical, biotechnology, or medical device industries--will find the philosophical best practices and implementation examples in this book invaluable.

This book is part of the SAS Press program.

A visual approach to data mining. Data mining has been defined as the search for useful and previously unknown patterns in large datasets, yet when faced with the task of mining a large dataset, it is not always obvious where to start and how to proceed. This book introduces a visual methodology for data mining demonstrating the application of methodology along with a sequence of exercises using VisMiner. VisMiner has been developed by the author and provides a powerful visual data mining tool enabling the reader to see the data that they are working on and to visually evaluate the models created from the data. Key features: Presents visual support for all phases of data mining including dataset preparation. Provides a comprehensive set of non-trivial datasets and problems with accompanying software. Features 3-D visualizations of multi-dimensional datasets. Gives support for spatial data analysis with GIS like features. Describes data mining algorithms with guidance on when and how to use. Accompanied by VisMiner, a visual software tool for data mining, developed specifically to bridge the gap between theory and practice. Visual Data Mining: The VisMiner Approach is designed as a hands-on work book to introduce the methodologies to students in data mining, advanced statistics, and business intelligence courses. This book provides a set of tutorials, exercises, and case studies that support students in learning data mining processes. In praise of the VisMiner approach: "What we discovered among students was that the visualization concepts and tools brought the analysis alive in a way that was broadly understood and could be used to make sound decisions with greater certainty about the outcomes"—Dr. James V. Hansen, J. Owen Cherrington Professor, Marriott School, Brigham Young University, USA "Students learn best when they are able to visualize relationships between data and results during the data mining process. VisMiner is easy to learn and yet offers great visualization capabilities throughout the data mining process. My students liked it very much and so did I." —Dr. Douglas Dean, Assoc. Professor of Information Systems, Marriott School, Brigham Young University, USA

Maximize the Value of Business Intelligence with IBM Cognos v10 -- Hands-on, from Start to Finish This easy-to-use, hands-on guide brings together all the information and insight you need to drive maximum business value from IBM Cognos v10. Long-time IBM Cognos expert and product designer Sangeeta Gautam thoroughly illuminates Cognos BI v10’s key capabilities: analysis, query, reporting, and dashboards. Gautam shows how to take full advantage of each key IBM Cognos feature, including brand-new innovations such as Active Reports and the new IBM Cognos Workspace report consumption environment. She concludes by walking you through successfully planning and implementing an integrated business intelligence solution using IBM’s best-practice methodologies. The first and only guide of its kind, offers expert insights for BI designers, architects, developers, administrators, project managers, nontechnical end-users, and partners throughout all areas of the business—from sales and marketing to operations and lines of business. If you’re pursuing official IBM Cognos certification, you’ll also find Cognos certification sample questions and information to help you with the certification process. IBM Cognos Business Intelligence v10 Coverage Includes • Understanding IBM Cognos BI’s components and open, extensible architecture • Working with IBM Cognos key “studio” tools: Analysis Studio, Query Studio, Report Studio, and Event Studio • Developing and managing powerful reports that draw on the rich capabilities of IBM Cognos Workspace and Workspace Advanced • Designing Star Schema databases and metadata models to answer the questions your organization cares about most • Efficiently maintaining and systematically securing IBM Cognos BI environments and their objects • Using IBM Cognos Connection as your single point of entry to all corporate data • Building interactive, easy-to-manage Active Reports for casual business users • Using new IBM Cognos BI v10.1 Dynamic Query Mode (DQM) to improve performance with complex heterogeneous data • Identifying, exploring, and exploiting hidden data relationships • Creating quick ad hoc queries that deliver fast answers • Establishing user and administrator roles

In 'QlikView 11 for Developers', you will learn how to leverage QlikView to create robust, insightful business intelligence applications. By following the case study of HighCloud Airlines, this book offers a practical, step-by-step guide to developing and mastering QlikView to address real-world data analysis needs. What this Book will help me do Build comprehensive QlikView dashboards with advanced techniques. Understand how to create associative data models by integrating different data sources. Design interactive user interfaces to enable insightful analysis. Apply best practices in QlikView scripting to transform and prepare data. Master QlikView's built-in functions for calculations and analyses. Author(s) The authors of 'QlikView 11 for Developers' bring extensive experience in business intelligence and QlikView application development. With backgrounds in software engineering and data visualization, they combine technical rigor with practical insights. Their teaching approach ensures concepts are accessible and actionable for a wide range of learners. Who is it for? This book is ideal for software developers and data analysts who want to harness QlikView to build business intelligence applications. It is tailored for those with a basic understanding of business intelligence looking to deepen their expertise in QlikView. The content is also valuable for power users seeking efficiency through advanced features. Readers will gain practical, hands-on knowledge by following this guide.

A classic that just keeps getting better, The Little SAS Book The fifth edition has been completely updated to reflect the new default output introduced with SAS 9.3. In addition, there is a now a full chapter devoted to ODS Graphics including the SGPLOT and SGPANEL procedures. Other changes include expanded coverage of linguistic sorting and a new section on concatenating macro variables with other text. This title belongs on every SAS programmer's bookshelf. It's a resource not just to get you started, but one you'll return to as you continue to improve your programming skills.

IBM® Cognos® Business Intelligence (BI) provides a proven enterprise BI platform with an open data strategy, providing customers with the ability to leverage data from any source, package it into a business model, and make it available to consumers in various interfaces that are tailored to the task. IBM Cognos Dynamic Cubes complements the existing Cognos BI capabilities and continues the tradition of an open data model. It focuses on extending the scalability of the IBM Cognos platform to enable speed-of-thought analytics over terabytes of enterprise data, without having to invest in a new data warehouse appliance. This capability adds a new level of query intelligence so you can unleash the power of your enterprise data warehouse. This IBM Redbooks® publication addresses IBM Cognos Business Intelligence V10.2 and specifically, the IBM Cognos Dynamic Cubes capabilities. This book can help you in the following ways: Understand core features of the Dynamic Cubes capabilities of IBM Cognos BI V10.2 Learn by example with practical scenarios using the IBM Cognos samples

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.

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.

Statisticians and researchers will find Categorical Data Analysis Using SAS, Third Edition, by Maura Stokes, Charles Davis, and Gary Koch, to be a useful discussion of categorical data analysis techniques as well as an invaluable aid in applying these methods with SAS. Practical examples from a broad range of applications illustrate the use of the FREQ, LOGISTIC, GENMOD, NPAR1WAY, and CATMOD procedures in a variety of analyses. Topics discussed include assessing association in contingency tables and sets of tables, logistic regression and conditional logistic regression, weighted least squares modeling, repeated measurements analyses, loglinear models, generalized estimating equations, and bioassay analysis.

The third edition updates the use of SAS/STAT software to SAS/STAT 12.1 and incorporates ODS Graphics. Many additional SAS statements and options are employed, and graphs such as effect plots, odds ratio plots, regression diagnostic plots, and agreement plots are discussed. The material has also been revised and reorganized to reflect the evolution of categorical data analysis strategies. Additional techniques include such topics as exact Poisson regression, partial proportional odds models, Newcombe confidence intervals, incidence density ratios, and so on.

This book is part of the SAS Press program.

In JMP, you choose from a wide repertoire of interactive graphs to help your data best tell its story. Delve into JMP 10 Basic Analysis and Graphing to find the ideal graph for your data, from basic distributions, bubble plots, scatterplots, and parallel plots to geographic maps and tree maps.

Understanding the basic concepts of character encoding is necessary for creating, manipulating, and rendering any type of character data. An encoding is involved whenever data is brought into SAS from various external sources; whenever data is transferred between SAS applications running different locales or across the network via thin clients; and when output is written to external files, SAS data sets, printers, or Web pages. In each of these cases, something can go wrong. It is the encoder’s responsibility to ensure that the data is stored, processed, and rendered in the correct encoding. Manfred Kiefer's SAS Encoding: Understanding the Details explains the basic concepts of characters, encodings, glyphs, and fonts and gives practical examples of how to troubleshoot encoding problems. Addressed to the beginner as well as to the advanced SAS user, this book can help solve your encoding problems. It provides background information about encodings, shows how they are used with SAS software, and explains typical problems and ways to sort those out. It also presents examples of how to set up SAS software in an international environment.

Fundamentals of Predictive Analytics with JMP bridges the gap between courses on basic statistics, which focus on univariate and bivariate analysis, and courses on data mining/predictive analytics. This book provides the technical knowledge and problem-solving skills needed to perform real data multivariate analysis. Utilizing JMP 10 and JMP Pro, this book offers new and enhanced resources, including an add-in to Microsoft Excel, Graph Builder, and data mining capabilities.

Written for students in undergraduate and graduate statistics courses, this book first teaches students to recognize when it is appropriate to use the tool, to understand what variables and data are required, and to know what the results might be. Second, it teaches them how to interpret the results, followed by step-by-step instructions on how and where to perform and evaluate the analysis in JMP.

With the new emphasis on business intelligence, business analytics and predictive analytics, this book is invaluable to everyone who needs to expand their knowledge of statistics and apply real problem-solving analysis.

This book is part of the SAS Press program.

The only authorized guide to IBM Cognos Business Intelligence v10.1 Updated for the latest release of the software, IBM Cognos Business Intelligence 10: The Official Guide explains how to create, implement, and manage an enterprise BI solution. Maximize all of the new and enhanced features, including the powerful modeling, monitoring, and analytics capabilities. Build and deliver reports that foster informed business decisions and better results. Filled with real-world examples and expert advice, this practical resource is ideal for anyone working with IBM Cognos Business Intelligence v10.1--from administrators to end users. Monitor performance using dashboards and scorecards Assign user roles and privileges Provide a single access point to application-specific data via Cognos Connection Access content from Microsoft Office applications and mobile devices Collect and analyze BI data in an interactive dashboard with Cognos Business Insight Use Cognos Administration tools for system management Implement appropriate security measures Create BI reports with relational and dimensional data using Business Insight Advanced Use Report Studio to build dimensional reports and statistical analyses Identify and deliver mission-critical information using Event Studio Monitor business performance with Metric Studio Create, modify, organize, and publish a model in Framework Manager Ensure report integrity with Lifecycle Manager

The IBM Cognos TM1 Developer's Certification Guide is your hands-on resource to preparing for and passing the COG-310 certification exam. This book offers a practical, example-driven approach to mastering the core concepts and tools within IBM Cognos TM1, including dimension construction, scripting with Turbo Integrator, rules writing, and cube design. What this Book will help me do Master the key components and architecture of Cognos TM1 to build efficient financial models. Gain proficiency in Turbo Integrator scripting to automate data integration and transformations. Learn to create and use dimensions, cubes, and rules effectively within the TM1 environment. Understand advanced concepts like drill-through functionality, virtual cubes, and lookup cubes. Enhance your data presentation and reporting skills tailored to TM1 solutions. Author(s) James D. Miller is an experienced educator and IBM Cognos TM1 professional, with a strong background in financial and enterprise planning systems. With years of experience in the field, James brings his practical knowledge into his writing, making complex technical topics approachable and clear. He is committed to helping learners achieve their professional certifications and enhance their skill sets. Who is it for? This book is ideal for beginner to intermediate IBM Cognos TM1 developers who are looking to gain expertise in the field and obtain the COG-310 certification. If you are someone interested in enhancing your financial modeling skills and advancing your career, this guide is designed to meet your needs. It suits individuals wishing for structured, hands-on learning with practical exercises to build actual project-ready competence. Anyone aiming to independently prepare for the COG-310 certification exam will greatly benefit from this content.

An essential guide to OHSAS 18001 We say 'take care' as we wave our loved ones goodbye in the morning, but how often is this message taken into the workplace? In this easy-to-understand and timely pocket guide, Naeem Sadiq, examines the Understanda as it gears up to meet OHSAS 18001 standards of occupational health and safety. Real-world scenarios Using a wide variety of fictional 'real world' scenarios, Sadiq demonstrates the hazards that might be present in a workplace, how to assess risk, how to manage OHSAS 18001 implementation and how to communicate its implementation through all levels of management. Sadiq takes the complex, and often impenetrable, concepts that surround health and safety and presents them with absolute precision and clarity. A sound understanding of OHSAS 18001 OHSAS 18001: Step by Step is more than a primer. Besides giving the reader a sound understanding of OHSAS 18001, the pocket guide can be used as a step-by-step instructional manual for anyone tasked with implementing operational health and safety standards in the workplace. This pocket guide gives its readers: A comprehensive explanation of OHSAS 18001 and its implications An understanding of how OHSAS 18001 can be implemented through the PDCI (Plan-Do-Check-Improve) management principle A 'how-to' guide for establishing an Occupational Health and Safety (OH&S) Policy A 'how-to' guide for identifying risks and controls within the organisation An understanding of the law; the legislative and contractual OH&S requirements to which an organisation subscribes An explanation of how OH&S objectives can be determined and established, and how to apportion responsibility and accountability throughout the organisation Clear understanding of OH&S accountability and the need for diligent record-keeping A 'how-to' guide for setting up a training, competence and awareness regime Understanding of how OHSAS 18001 protects not just colleagues, but customers and contractors who enter your workplace Expert guidance on how to deal with emergencies. " Buy this pocket guide and protect your workforce with OHSAS 18001!

Updated for JMP 10, the book provides hands-on tutorials with just the right amount of conceptual and motivational material to illustrate how to use the intuitive interface for data analysis in JMP. Features concept-specific tutorials, examples, brief reviews of concepts, step-by-step illustrations, and exercises.

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.