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.

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.

This comprehensive guide introduces you to the functionalities of MicroStrategy for business intelligence, empowering you to build dashboards, reports, and visualizations using hands-on, practical recipes with clear examples. You'll learn how to use MicroStrategy for the entire BI lifecycle, making data actionable and insights accessible. What this Book will help me do Install and configure the MicroStrategy platform, including setting up a fully operational BI environment. Create interactive dashboards and web reports to visualize and analyze data effectively. Learn to use MicroStrategy on mobile devices, enabling access to data-driven insights anywhere. Discover advanced analytics techniques using Visual Insight and MicroStrategy Cloud Express. Master practical skills with real-life examples to implement robust BI solutions. Author(s) Davide Moraschi, an experienced professional in business intelligence and data analytics, brings his expertise to guiding readers through the MicroStrategy platform. He has years of experience implementing and developing BI solutions in diverse industries, offering practical perspectives. Davide's approachable teaching style and clear examples make technical concepts accessible and engaging. Who is it for? This book is tailored for BI developers and data analysts who want to deepen their expertise in MicroStrategy. It's also suitable for IT professionals and business users aiming to leverage MicroStrategy for data insights. Some existing knowledge of BI concepts, such as dimensional modeling, will enrich your learning experience. You need no prior experience with MicroStrategy to benefit from this book.

This book is a comprehensive guide designed for those new to Pentaho Data Integration. With a focus on practical application and step-by-step learning, this book covers everything from installation to complex data manipulation. By following along, you will acquire the skills you need to efficiently manage and transform data using Pentaho. What this Book will help me do Understand how to install and set up Pentaho Data Integration for professional data manipulation. Master data transformation tasks such as cleaning, sorting, and integrating different data sources. Learn to configure and operate databases within the Pentaho environment, including CRUD operations. Gain hands-on experience with data warehousing concepts and using Pentaho to populate data warehouses. Develop workflows and schedules for automated data processes using Pentaho's advanced tools. Author(s) Carina Roldán is an experienced data professional with extensive expertise in the field of ETL and data integration. Her teaching style is clear, approachable, and heavily reliant on practical examples. She focuses on enabling learners to build real-world skills in a supportive and engaging manner, making complex topics accessible to everyone. Who is it for? This book is perfect for developers, database administrators, and IT professionals looking to venture into ETL tools or seeking a deeper understanding of Pentaho Data Integration. Beginners without prior exposure to Pentaho Data Integration will find it an excellent entry point, while those with some experience will benefit from its in-depth insights. It is also valuable for data warehouse designers and architects aiming to streamline their workflows.

You've just received a new survey of study results, and you need to quickly create custom graphical views of the data. Or, you've completed your analysis, and you need graphs to present the results to your audience, in the style that they prefer. Now, you can create custom graphs quickly and easily with Getting Started with the Graph Template Language in SAS, without having to understand all of the Graph Template Language (GTL) features first.

This book will get you started building graphs immediately and will guide you toward a better understanding of the GTL, one step at a time. It shows you the most common approaches to a variety of graphs along with information that you can use to build more complex graphs from there. Sanjay Matange offers expert tips, examples, and techniques, with a goal of providing you with a solid foundation in using the GTL so that you can progress to more sophisticated, adaptable graphs as you need them.

Ultimately, Getting Started with the Graph Template Language in SAS allows you to bypass the learning curve. It teaches you how to quickly create custom, aesthetically pleasing graphs that present your data with maximum clarity and minimum clutter.

This book is part of the SAS Press program.

KNIME Essentials is a comprehensive guide to mastering KNIME, an open-source data analytics platform. Through this book, you'll discover how to process, visualize, and report on data effectively. Whether you're new to KNIME or data analytics in general, this resource is designed to equip you with the skills needed to handle data challenges confidently. What this Book will help me do Understand how to install and set up KNIME for data analysis tasks. Learn to create workflows to efficiently process data. Explore methods for importing and pre-processing data from various sources. Master techniques for visualizing and analyzing processed data. Generate professional-grade reports based on your data visualizations. Author(s) Gábor Bakos, the author of KNIME Essentials, leverages his expertise in data analytics and software tools to provide readers with a practical guide to mastering KNIME. With years of experience in working with analytics platforms, he crafts content that is accessible and focused on delivering real-world results. His user-focused approach helps readers quickly grasp complex concepts. Who is it for? This book is ideal for data analysts and professionals seeking to enhance their data processing skills with KNIME. No prior knowledge of KNIME is expected, but a foundational understanding of data analytics concepts would be beneficial. If you're looking to produce insightful analytics and reports efficiently, this guide is tailored for you.

Partial Least Squares (PLS) is a flexible statistical modeling technique that applies to data of any shape. It models relationships between inputs and outputs even when there are more predictors than observations. Using JMP statistical discovery software from SAS, Discovering Partial Least Squares with JMP explores PLS and positions it within the more general context of multivariate analysis.

Ian Cox and Marie Gaudard use a “learning through doing” style. This approach, coupled with the interactivity that JMP itself provides, allows you to actively engage with the content. Four complete case studies are presented, accompanied by data tables that are available for download. The detailed “how to” steps, together with the interpretation of the results, help to make this book unique.

Discovering Partial Least Squares with JMP is of interest to professionals engaged in continuing development, as well as to students and instructors in a formal academic setting. The content aligns well with topics covered in introductory courses on: psychometrics, customer relationship management, market research, consumer research, environmental studies, and chemometrics. The book can also function as a supplement to courses in multivariate statistics and to courses on statistical methods in biology, ecology, chemistry, and genomics.

While the book is helpful and instructive to those who are using JMP, a knowledge of JMP is not required, and little or no prior statistical knowledge is necessary. By working through the introductory chapters and the case studies, you gain a deeper understanding of PLS and learn how to use JMP to perform PLS analyses in real-world situations.

This book motivates current and potential users of JMP to extend their analytical repertoire by embracing PLS. Dynamically interacting with JMP, you will develop confidence as you explore underlying concepts and work through the examples. The authors provide background and guidance to support and empower you on this journey.

This book is part of the SAS Press program.

This IBM® Redbooks® publication explains how IBM Cognos® Business Intelligence (BI) administrators, authors, modelers, and power users can use the dynamic query layer effectively. It provides guidance for determining which technology within the dynamic query layer can best satisfy your business requirements. Administrators can learn how to tune the query service effectively and preferred practices for managing their business intelligence content. This book includes information about metadata modeling of relational data sources with IBM Cognos Framework Manager. It includes considerations that can help you author high-performing applications that satisfy analytical requirements of users. This book provides guidance for troubleshooting issues related to the dynamic query layer of Cognos BI.

Discovering JMP 11 provides a basic introduction to using JMP. For new users of JMP, this is a great place to start. The book also includes details about importing your data into JMP, analyzing the data, and sharing the results.

JMP 11 Basic Analysis covers the initial types of analyses that you often perform in JMP, such as univariate, bivariate, and oneway analyses. Creating tables of summary statistics with the Tabulate platform is included along with approximating sampling distributions using bootstrapping.

JMP 11 Consumer Research focuses on analyses that help users observe and predict subject's behavior, particularly those in the market research field. The Uplift platform predicts consumer behavior based on shifts in marketing efforts. Learn how to tabulate and summarize categorical responses with the Categorical platform. Factor Analysis rotates principal components to help identify which directions have the most variation among the variables. The book also covers Item Analysis, a method for identifying latent traits that might affect an individual's choices. And read about the Choice platform, which market researchers use to estimate probability in consumer spending.

The JMP 11 Design of Experiments Guide covers classic DOE designs (for example, full factorial, response surface, and mixture designs). Read about more flexible custom designs, which you generate to fit your particular experimental situation. And discover JMP's definitive screening designs, an efficient way to identify important factor interactions using fewer runs than required by traditional designs. The book also provides guidance on determining an appropriate sample size for your study.

Start with JMP 11 Essential Graphing to find the ideal graph for your data. The book begins with Graph Builder, a quick way to create graphs in a drag-and-drop window. Line charts, ellipses, box plots, and maps are just a few of the graphs available in Graph Builder. Find information about creating other types of plots: bubble plots, scatterplots, parallel plots, and more.

JMP 11 Fitting Linear Models focuses on the Fit Model platform and many of its personalities. Linear and logistic regression, analysis of variance and covariance, and stepwise procedures are covered. Also included are multivariate analysis of variance, mixed models, generalized models, and models based on penalized regression techniques.

The JMP 11 JSL Syntax Reference focuses on functions and their arguments, and messages that you send to objects and display boxes. Notes and examples are included.

Whether your model is deterministic, or involves necessary “noise” as well as a “signal,” JMP is equipped to handle your modeling needs. JMP 11 Multivariate Methods shows you how to take advantage of the modeling platforms Multivariate, Cluster, Discriminant, Principal Components, and Partial Least Squares.

JMP 11 Profilers covers the family of interactive profiling tools, which enable you to view cross-sections of any response surface. The book also includes details about plotting points and surfaces in a three-dimensional graph. JMP 11 Profilers covers the family of interactive profiling tools, which enable you to view cross-sections of any response surface. The book also includes details about plotting points and surfaces in a three-dimensional graph.

Quality and Process Methods describes tools for evaluating and improving processes. The book begins by discussing creating control charts, which let you visualize process measurements over time, quantify common cause variation, and identify special cause variation. Details about estimating your process capability based on measurement systems analysis studies are included. Lastly, the book discusses Pareto plots and cause-and-effect diagrams to identify root causes of variability.

JMP 11 Reliability and Survival Methods provides details about evaluating and improving reliability in a product or system and analyzing survival data for people and products. The book explains how to fit the best distribution to your time-to-event data or analyze destruction data. A few other topics include analyzing competing causes of failure, modeling reliability as improvements are made over time, and analyzing recurring events.

Scripting Guide provides details for taking advantage of the powerful JMP Scripting Language (JSL). Learn how to write and debug scripts, manipulate data tables, construct display boxes, create JMP applications, and more.