The world-wide developer community has downloaded over three million copies of BIRT (Business Intelligence and Reporting Tools) from the Eclipse web site. Built on the open-source Eclipse platform, BIRT is a powerful reporting system that provides an end-to-end solution, from creating and deploying reports to integrating report capabilities in enterprise applications. The first in a two-book series about this exciting technology, is the authoritative guide to using BIRT Report Designer, the graphical tool that enables users of all levels to build reports, simple to sophisticated, without any programming. BIRT, Second Edition: A Field Guide to Reporting is an essential resource for users who want to create presentation quality reports from day one. The extensive examples, step-by-step instructions, and abundant illustrations help new users develop their report design skills quickly. Power users can find the information they need to make the most of the product’s rich set of features to build complex and compelling reports. By the time you finish this book, you learn the following and more BIRT, Second Edition: A Field Guide to Reporting Design effective business and corporate reports that convey information through images, charts, tables, and cross tabs Build reports using data from a variety of sources, including databases, XML documents, spreadsheets, and web services Enliven reports with interactive features, such as hyperlinks, Tooltips, and highlighting Create consistently styled reports and collaborate with other report designers through the use of templates and libraries of reusable elements Localize reports for an international audience This second edition, revised and expanded, adds updated examples and covers all the new and improved product features, including Cross tabs and OLAP cubes New chart types, including Gantt, bubble, tube, and cone charts Web services as a new data source New report output formats, including doc, ppt, xls, and PostScript The capability for reports to reference CSS Localization of report parameter and data values

Now in its fourth edition, The Little SAS Book is a classic, helping many people learn SAS programming. Authors Lora Delwiche and Susan Slaughter's friendly, easy-to-read writing style gently introduces readers to the most commonly used features of the SAS language. Topics include basic SAS concepts such as the DATA and PROC steps, inputting data, modifying and combining data sets, summarizing data, producing reports, and debugging SAS programs. Each topic is presented in a self-contained two-page layout complete with examples and graphics. This clear and concise format enables new users to get up and running quickly, while the examples allow readers to type in the program and see it work! New topics in the fourth edition include ODS Graphics for statistical procedures, PROC SGPLOT for graphics, creating new variables in PROC REPORT with a COMPUTE block, WHERE= data set option, SORTSEQ=LINGUISTIC option in PROC SORT, and more functions, including ANYALPHA, CAT, PROPCASE, and YRDIF.

The Only Authorized Guide to IBM Cognos 8 Business Intelligence Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users. Measure and monitor performance using dashboards and scorecards Assign user roles and privileges Provide complete and consistent access to a broad range of data sources via Cognos Connection Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines Enable business users to create reports with Query Studio Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio Build Dimensional Reports with Report Studio Use Event Studio to identify and deliver mission-critical information Create, modify, organize, and publish a model from Cognos Framework Manager Implement sound security measures Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

Debra Dalgleish, Microsoft Office Excel "Most Valuable Professional" since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts. You'll find this book inimitable when facing any new or difficult problem in PivotTables, covering the entire breadth of situations you could ever encounter, from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The author presents tips and techniques in this collection of recipes that can't be found in Excel's Help section, while carefully explaining the most confusing features of PivotTables to help you realize their powerful potential. The chapters in this book have been organized into a collection of recipes to take you step by step from the problem you are experiencing to the solution you are aiming for. Without fuss, you'll find clear and precise information to help you assess your situation, whether common or unique, and solve your problem. Working examples of complex PivotTables and numerous PivotTable programming examples will help you solve problems quickly, without the need to digest heavy content.

Though many consumers know the basics of using Excel, few users understand the powerful capabilities of the PivotTable and PivotChart features. These tools can help turn long lists of unreadable data into dynamically generated, easy-to-read tables and charts that highlight useful and pertinent business information. Companies rely on this type of data from marketing, accounting, and finance to help make better decisions about products, sales and even human resources. Charts are interactive, allowing the consumer to tweak results with the click of a mouse and PivotTables allow you to fuse data from several sources into one document. This book shows users how to work with PivotTables and PivotCharts to make sense of their data. It covers features such as: understanding PivotTable benefits and uses; creating and customizing PivotTables; using PivotTables to analyze business data; building custom calculations; linking to external data sources, including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes; publishing PivotTables to the Web; multiple consolidation of data, for example, summarizing annual fiscal data by quarters; preparing financial reporting, budgeting, and data analysis across departments; and using VBA to create macros that automate frequently used PivotTable tasks.

Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data. Carefully explains the benefits of using Pivot Tables for fast data analysis Provides a step-by-step approach to those new to Pivot Tables Offers tips and tricks that cannot be found elsewhere

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.

The indispensable, up-to-date guide to mixed models using SAS. Discover the latest capabilities available for a variety of applications featuring the MIXED, GLIMMIX, and NLMIXED procedures in SAS for Mixed Models, Second Edition, the comprehensive mixed models guide for data analysis, completely revised and updated for SAS 9 by authors Ramon Littell, George Milliken, Walter Stroup, Russell Wolfinger, and Oliver Schabenberger. The theory underlying the models, the forms of the models for various applications, and a wealth of examples from different fields of study are integrated in the discussions of these models: random effect only and random coefficients models; split-plot, multilocation, and repeated measures models; hierarchical models with nested random effects; analysis of covariance models; spatial correlation models; generalized linear mixed models; and nonlinear mixed models.

Professionals and students with a background in two-way ANOVA and regression and a basic knowledge of linear models and matrix algebra will benefit from the topics covered.

This book is part of the SAS Press program.

Created in partnership with SAS, this book explores SAS, a business intelligence software that can be used in any business setting or enterprise for data delivery, reporting, data mining, forecasting, statistical analysis, and more. SAS employee and technologist Stephen McDaniel combines real-world expertise and a friendly writing style to introduce readers to SAS basics. It covers crucial topics such as getting various types of data into the software, producing reports, working with the data, basic SAS programming, macros, and working with SAS and databases.

Need help understanding the SAS macro facility? You will find all the answers that you need in this easy-to-follow book! Michele Burlew puts her decades of macro programming experience to work for you as she guides you through the basics, as well as the more complex features of the SAS macro facility. Updated extensively for SAS 9, this book includes plenty of examples and step-by-step instructions. You will learn the elements of the macro facility (macro variables, macro programs, macro language), how to write a macro program, macro programming techniques, 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. New topics for the second edition include using SAS 9 macro and SAS language features, debugging macro programs, adding error checking to macro programs, and building a library of utility macro programs. Beginning macro programmers will learn to write SAS macro programs quickly and efficiently. More experienced macro programmers will find this book useful to refresh their conceptual knowledge and expand on their macro programming skills. It is also important to note that the macro facility is a highly popular part of SAS and found in the job requirements for many SAS programming jobs. In addition, macro facility concepts are tested on the SAS Advanced Programming Exam. The book assumes some SAS programming experience, including knowledge of how to write a DATA step and how to use SAS procedures.

Learn to program SAS by example!

If you like learning by example, then Learning SAS by Example: A Programmer's Guide makes it easy to learn SAS programming. 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 Learning to use the SAS Output Delivery System Getting started with the SAS macro language Introducing PROC SQL

You can test your knowledge and hone your skills by solving the problems at the end of each chapter. (Solutions to odd-numbered problems are located at the back of this book. Solutions to all problems are available to instructors by visiting Ron Cody's author page for details.) This book is intended for beginners and intermediate users. Readers should know how to enter and submit a SAS program from their operating system.

This book is part of the SAS Press program.

Written for anyone involved in the data preparation process for analytics, Gerhard Svolba's Data Preparation for Analytics Using SAS offers practical advice in the form of SAS coding tips and tricks, and provides the reader with a conceptual background on data structures and considerations from a business point of view. The tasks addressed include viewing analytic data preparation in the context of its business environment, identifying the specifics of predictive modeling for data mart creation, understanding the concepts and considerations of data preparation for time series analysis, using various SAS procedures and SAS Enterprise Miner for scoring, creating meaningful derived variables for all data mart types, using powerful SAS macros to make changes among the various data mart structures, and more!

A new edition of this title is available, ISBN-10: 0321580303 ISBN-13: 9780321580306 The second of a two-book series about business intelligence and reporting technology, introduces programmers to BIRT architecture and the reporting framework. Built on the Eclipse platform, this exciting technology makes it possible for programmers to build and deploy customized reports using scripting and BIRT APIs. In addition, programmers can extend the BIRT framework by building new plug-ins using the Eclipse Plug-in Development Environment. Integrating and Extending BIRT This book describes the key components of BIRT architecture, applications, and engines, including installing, deploying, and troubleshooting the Reporting and Charting engines in an Enterprise Java application-server environment.For developers who wish to incorporate custom business logic in their reports or access data from Java objects, the book describes BIRT's extensive scripting capabilities in JavaScript and Java. For developers who want to extend the BIRT framework, the book describes the key extension points to use in creating customized report items, rendering extensions for generating output other than HTML or PDF, and Open Data Access (ODA) drivers for new data sources. The book provides extensive examples of how to build plug-ins to extend the features of the BIRT framework. Topics discussed include Installing and deploying BIRT Deploying a BIRT report to an application server Understanding BIRT architecture Scripting in a BIRT report design Integrating BIRT functionality in applications Working with the BIRT extension framework

You'll gain a world of knowledge through Phil Mason's inventive tips and techniques. Updated and expanded to cover the breadth of functionality offered in SAS 8 and SAS 9, In the Know...SAS Tips and Techniques From Around the Globe, Second Edition, is packed with timeless classics and plenty of new material addressing such popular topics as the DATA step, SQL, macros, functions, ODS, and much more. Each tip is presented in a self-contained format that is both informative and easy to use. Every chapter contains a collection of related tips with frequent use of code and log examples to help improve productivity. Users of all levels will discover how to save time and effort by incorporating the wisdom found in these practical tips.

A new edition of this title is available, ISBN-10: 0321580273 ISBN-13: 9780321580276 The first in a two-book series about Business Intelligence and Reporting Technology, introduces reporting to a broad base of users. Built on the Eclipse platform, this exciting technology makes it possible for programmers and non-programmers to build and deploy complex reports with minimal effort. BIRT: A Field Guide to Reporting presents information about how to develop and customize reports of progressive complexity using BIRT Report Designer. This tool was designed from the ground up for Web applications and uses a Web page-oriented design metaphor in contrast to older banded report writers that were developed before the advent of the Internet. This unique approach to report creation makes BIRT an approachable and effective tool for developers of all levels. BIRT: A Field Guide to Reporting Report designs discussed include Listing reports that include sorting, grouping, and totals Summary reports, such as top N reports Charts, including pie, line, bar, and gauge charts Master-detail reports Other topics discussed include Understanding the technology Planning report designs Accessing data Laying out and formatting reports Building charts Enhancing reports with interactive viewing, shared libraries, and localized text Preparing reports for international data

Learning to use SAS Enterprise Guide has never been easier! With The Little SAS Book for Enterprise Guide 4.1, Susan Slaughter and Lora Delwiche help you quickly become familiar with the SAS Enterprise Guide point-and-click environment. A series of carefully designed tutorials help you master the basics of the tasks you will want to do most frequently. The reference section of the book expands on the tutorial topics, focusing on specific features. If you are new to SAS or new to SAS Enterprise Guide, this book will be an invaluable tool on your way to becoming an expert.

Generate detailed reports that will give your company the competitive edge Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10 g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10 g. Set up, configure, and manage Oracle Business Intelligence Discoverer 10 g Perform ad hoc and fixed queries using the Workbook Wizard Integrate sorts, calculations, percentages, and parameters using Discoverer Plus Create reports with graphs, tables, titles, headers, footers, and margins Use Discoverer Viewer to review, format, export, email, and print reports Refine queries using interactive pivoting, drilling, and Hyper Drilling Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager Establish access and sharing rights, and scheduling privileges with Discoverer Administrator Set up and use Portal using Discoverer Portlet Provider and Portlets Implement query shortcuts, cascading parameters and advanced analytic calculations using templates

Prepare for the SAS Base Programming for SAS®9 certification exam with the official guide by the SAS® Certified Professional Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS®9 certification exam will find this guide an invaluable, convenient and comprehensive resource that covers all of the objectives tested on the exam. Major topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors.You will also become familiar with the enhancements and new functionality that are available in SAS®9. Includes a free CD-ROM with tutorials, practice data, and sample programs to further reinforce and test your SAS skills.

Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables—from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for. There's no fuss to this book, only clear and precise information to help you assess your situationwhether common or uniqueand solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.

At last! A real-world reference guide for clinical trial SAS programming, packed with solutions that programmers can apply to their day-to-day problems. Discover key techniques and tools available within Base SAS (including the macro language and PROC SQL), SAS/GRAPH, and SAS/STAT that can be used to resolve many common issues in working with clinical trial data. Organized to reflect the statistical programmer's work flow, this user-friendly text begins with an introduction to the working environment, then presents chapters on importing and massaging data into analysis data sets, producing clinical trial output, and exporting data. Valuable plug-and-play programming examples are provided throughout. Whether you're a novice seeking an introduction to SAS programming for the pharmaceutical industry or a junior-level programmer exploring new approaches to problem solving, you'll find a wealth of practical suggestions to help you sharpen your skills.

Jump-start your report-writing skills! Report writing has never been easier. Learn how you can easily avoid common report-writing pitfalls with SAS Guide to Report Writing: Examples, Second Edition. Updated for SAS®9, this task-oriented book guides you through the steps that you need to produce professional reports. Using a wealth of easy-to-follow examples, this time-saving book demonstrates the many different styles of reports that are available and the SAS tools used to generate them. The examples enable more experienced programmers to quickly grasp new techniques, while margin notes and additional discussions provide novice users with the details that they need for effective learning. You can save programming hours by using the SAS programs as they are or as models for developing your own reports. Whether you are a beginner or an expert, this must-have guide will strengthen your report-writing expertise and give you the tools that you need to enhance the power of your reports!

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

In Analysis of Clinical Trials Using SAS: A Practical Guide, Alex Dmitrienko, Geert Molenberghs, Christy Chuang-Stein, and Walter Offen bridge the gap between modern statistical methodology and real-world clinical trial applications. Step-by-step instructions illustrated with examples from actual trials and case studies serve to define a statistical method and its relevance in a clinical trials setting and to illustrate how to implement the method rapidly and efficiently using the power of SAS software. Topics reflect the International Conference on Harmonization (ICH) guidelines for the pharmaceutical industry and address important statistical problems encountered in clinical trials, including analysis of stratified data, incomplete data, multiple inferences, issues arising in safety and efficacy monitoring, and reference intervals for extreme safety and diagnostic measurements. Clinical statisticians, research scientists, and graduate students in biostatistics will greatly benefit from the decades of clinical research experience compiled in this book. Numerous ready-to-use SAS macros and example code are included.

This book is part of the SAS Press program.

Master the language of PROC SQL! Get faster and better results when you use the SQL procedure with this step-by-step, example-driven guide in your hands. You will find information about implementing both American National Standards Institute (ANSI) guidelines and non-ANSI features. A broad range of SAS users, including applications programmers, database designers and administrators, statisticians, and systems analysts, will find techniques in Kirk Lafler's PROC SQL: Beyond the Basics Using SAS to enhance their data access, manipulation, and presentation prowess. Topics examined include database design; an introduction to SQL, dictionary tables, and tables; coding PROC SQL logic as well as complex queries; working with views; troubleshooting and debugging SQL code; and tuning for performance. With the growing popularity of databases, PROC SQL is becoming the language of choice for SAS users around the world. Intermediate and advanced users will appreciate the straightforward explanations and numerous examples.

Getting started with SAS is easy with The Little SAS Book. This friendly, easy-to-read guide gently introduces you to the most commonly used features of SAS software plus a whole lot more! The book has been revised to include concepts of the Output Delivery System; the STYLE= option in the PRINT, REPORT, and TABULATE procedures; ODS HTML, RTF, PRINTER, and OUTPUT destinations; PROC REPORT; more on PROC TABULATE; exporting data; and the colon modifier for informats. You'll find clear and concise explanations of basic SAS concepts (such as DATA and PROC steps), inputting data, modifying and combining data sets, summarizing and presenting data, basic statistical procedures, and debugging SAS programs. Each topic is presented in a self-contained, two-page layout complete with examples and graphics. This format enables new users to get up and running quickly, while the examples allow you to type in the program and see it work!