Regarding online transaction processing (OLTP) workloads, IBM® z Systems™ platform, with IBM DB2®, data sharing, Workload Manager (WLM), geoplex, and other high-end features, is the widely acknowledged leader. Most customers now integrate business analytics with OLTP by running, for example, scoring functions from transactional context for real-time analytics or by applying machine-learning algorithms on enterprise data that is kept on the mainframe. As a result, IBM adds investment so clients can keep the complete lifecycle for data analysis, modeling, and scoring on z Systems control in a cost-efficient way, keeping the qualities of services in availability, security, reliability that z Systems solutions offer. Because of the changed architecture and tighter integration, IBM has shown, in a customer proof-of-concept, that a particular client was able to achieve an orders-of-magnitude improvement in performance, allowing that client’s data scientist to investigate the data in a more interactive process. Open technologies, such as Predictive Model Markup Language (PMML) can help customers update single components instead of being forced to replace everything at once. As a result, you have the possibility to combine your preferred tool for model generation (such as SAS Enterprise Miner or IBM SPSS® Modeler) with a different technology for model scoring (such as Zementis, a company focused on PMML scoring). IBM SPSS Modeler is a leading data mining workbench that can apply various algorithms in data preparation, cleansing, statistics, visualization, machine learning, and predictive analytics. It has over 20 years of experience and continued development, and is integrated with z Systems. With IBM DB2 Analytics Accelerator 5.1 and SPSS Modeler 17.1, the possibility exists to do the complete predictive model creation including data transformation within DB2 Analytics Accelerator. So, instead of moving the data to a distributed environment, algorithms can be pushed to the data, using cost-efficient DB2 Accelerator for the required resource-intensive operations. This IBM Redbooks® publication explains the overall z Systems architecture, how the components can be installed and customized, how the new IBM DB2 Analytics Accelerator loader can help efficient data loading for z Systems data and external data, how in-database transformation, in-database modeling, and in-transactional real-time scoring can be used, and what other related technologies are available. This book is intended for technical specialists and architects, and data scientists who want to use the technology on the z Systems platform. Most of the technologies described in this book require IBM DB2 for z/OS®. For acceleration of the data investigation, data transformation, and data modeling process, DB2 Analytics Accelerator is required. Most value can be archived if most of the data already resides on z Systems platforms, although adding external data (like from social sources) poses no problem at all.

Filled with helpful examples and real-life projects of SAS users, A Recipe for Success Using SAS University Edition is an easy guide on how to start applying the analytical power of SAS to real-world scenarios. This book shows you: how to start using analytics how to use SAS to accomplish a project goal how to effectively apply SAS to your community or school how users like you implemented SAS to solve their analytical problems A beginner’s guide on how to create and complete your first analytics project using SAS University Edition, this book is broken down into easy-to-read chapters that also include quick takeaway tips. It introduces you to the vocabulary and structure of the SAS language, shows you how to plan and execute a successful project, introduces you to basic statistics, and it walks you through case studies to inspire and motivate you to complete your own projects. Following a recipe for success using this book, harness the power of SAS to plan and complete your first analytics project!

What IS customer intelligence? What is a customer? Is the customer best understood by breaking the word down into its component parts: "cuss" and "tumor?" Would that be an intelligent thing to do? Will these and related questions some day be answered by self-aware machines? Will any of these questions be answered on this episode? Give it a listen and find out! The mish-mash of companies, products, and miscellany mentioned on this show include: Adobe, Oracle/ATG, SAS Customer Intelligence, Salesforce.com, Scott Brinker (Chief Martec), Domo, Data Studio 360, Tableau, iJento, Netezza, SPSS, Unfrozen Caveman Lawyer, Eight Is Enough, Legend of the Plaid Dragon (and the Slack version), Office Vibe, p-value article on fivethirtyeight.com (and the p-hacking app), and the "AI, Deep Learning, and Machine Learning" video.

Enhance your SAS® data wrangling skills with high precision and parallel data manipulation using the new DS2 programming language.

This book addresses the new DS2 programming language from SAS, which combines the precise procedural power and control of the Base SAS DATA step language with the simplicity and flexibility of SQL. DS2 provides simple, safe syntax for performing complex data transformations in parallel and enables manipulation of native database data types at full precision. It also introduces PROC FEDSQL, a modernized SQL language that blends perfectly with DS2. You will learn to harness the power of parallel processing to speed up CPU-intensive computing processes in Base SAS and how to achieve even more speed by processing DS2 programs on massively parallel database systems. Techniques for leveraging Internet APIs to acquire data, avoiding large data movements when working with data from disparate sources, and leveraging DS2’s new data types for full-precision numeric calculations are presented, with examples of why these techniques are essential for the modern data wrangler.

While working through the code samples provided with this book, you will build a library of custom, reusable, and easily shareable DS2 program modules, execute parallelized DATA step programs to speed up a CPU-intensive process, and conduct advanced data transformations using hash objects and matrix math operations.

IBM® TS7700 is a family of mainframe virtual tape solutions that optimize data protection and business continuance for IBM z Systems™ data. Through the use of virtualization and disk cache, the TS7700 family operates at disk speeds while maintaining compatibility with existing tape operations. Its fully integrated tiered storage hierarchy takes advantage of both disk and tape technologies to deliver performance for active data and best economics for inactive and archive data. This IBM Redbooks® publication describes the TS7700 R3.3 architecture, planning, migration, implementation, and operations. The latest TS7700 family of z Systems tape virtualization is offered as two models: IBM TS7720 features encryption-capable high-capacity cache that uses 3 TB SAS disk drives with RAID 6, which can scale to large capacities with the highest level of data protection. IBM TS7740 features encryption-capable 600 GB SAS drives with RAID 6 protection. Both models write data by policy to physical tape through attachment to high-capacity, high-performance IBM TS1150 and earlier IBM 3592 model tape drives that are installed in IBM TS3500 tape libraries. Physical tape support is optional on TS7720. TS7700 R3.3 also supports external key management for disk-based encryption by using IBM Security Key Lifecycle Manager. This book intended for system architects who want to integrate their storage systems for smoother operation.

By discussing statistical concepts in the context of transportation planning and operations, this text provides the necessary background for making informed transportation-related decisions. It explains the why behind standard methods and uses real-world transportation examples and problems to illustrate key concepts. The book covers the statistical techniques most frequently employed by transportation and pavement professionals. To familiarize readers with the underlying theory and equations, it contains problems that can be solved using SAS's JMP package, which enables users to interactively explore and visualize data.

Explore the mysteries of Exploratory Factor Analysis (EFA) with SAS with an applied and user-friendly approach.

Exploratory Factor Analysis with SAS focuses solely on EFA, presenting a thorough and modern treatise on the different options, in accessible language targeted to the practicing statistician or researcher. This book provides real-world examples using real data, guidance for implementing best practices in the context of SAS, interpretation of results for end users, and it provides resources on the book's author page. Faculty teaching with this book can utilize these resources for their classes, and individual users can learn at their own pace, reinforcing their comprehension as they go.

Exploratory Factor Analysis with SAS reviews each of the major steps in EFA: data cleaning, extraction, rotation, interpretation, and replication. The last step, replication, is discussed less frequently in the context of EFA but, as we show, the results are of considerable use. Finally, two other practices that are commonly applied in EFA, estimation of factor scores and higher-order factors, are reviewed. Best practices are highlighted throughout the chapters.

A rudimentary working knowledge of SAS is required but no familiarity with EFA or with the SAS routines that are related to EFA is assumed.

Using SAS University Edition? You can use the code and data sets provided with this book. This helpful link will get you started: http://support.sas.com/publishing/import_ue.data.html

The SAS Programmer's PROC REPORT Handbook: Basic to Advanced Reporting Techniques is intended for programmers of all skill levels. Learn how to link multiple reports, add graphics and logos, and manipulate table of contents values to help refine your programs, macrotize where possible, troubleshoot easily, and get great-looking reports every time. From beginner to advanced, the examples in this book will help you harness all the power and capability of PROC REPORT.

With dozens of useful examples, this book is completely unique in three ways. First, this book describes the default behavior of table of contents nodes and labels, and how to change the nodes inside of PROC REPORT. The chapter also explains how to use PROC DOCUMENT in conjunction with PROC REPORT. Secondly, an entire chapter is dedicated to the troubleshooting of errors, warnings, and notes that are produced by PROC REPORT, including explanations of what generated the log message and how to avoid it. Third, the book explains how to preprocess your data in order to get the best output from PROC REPORT, and it explores reports that require multiple steps to create. Whether you work in banking/finance, pharmaceuticals, the health and life sciences, or government, this handbook is sure to be your new favorite reporting reference.

SAS users in the Health and Life Sciences industry need to create complex graphs to analyze biostatistics data and clinical data, and they need to submit drugs for approval to the FDA. Graphs used in the HLS industry are complex in nature and require innovative usage of the graphics features. Clinical Graphs Using SAS® provides the knowledge, the code, and real-world examples that enable you to create common clinical graphs using SAS graphics tools, such as the Statistical Graphics procedures and the Graph Template Language.

This book describes detailed processes to create many commonly used graphs in the Health and Life Sciences industry. For SAS® 9.3 and SAS® 9.4 it covers many improvements in the graphics features that are supported by the Statistical Graphics procedures and the Graph Template Language, many of which are a direct result of the needs of the Health and Life Sciences community. With the addition of new features in SAS® 9.4, these graphs become positively easy to create.

Topics covered include the usage of SGPLOT procedure, the SGPANEL procedure and the Graph Template Language for the creation of graphs like forest plots, swimmer plots, and survival plots.

The issue facing most SAS programmers today is not that data space has become bigger ("Big Data"), but that our programming problem space has become bigger. Through the power of DS2, this book shows programmers how easily they can manage complex problems using modular coding techniques.

The DS2 Procedure: SAS Programming Methods at Work outlines the basic structure of a DS2 program and teaches you how each component can help you address problems. The DS2 programming language in SAS 9.4 simplifies and speeds data preparation with user-defined methods, storing methods and attributes in shareable packages, and threaded execution on multicore symmetric multiprocessing (SMP) and massively parallel processing (MPP) machines. This book is intended for all BASE SAS programmers looking to learn about DS2; readers need only an introductory level of SAS to get started. Topics covered include introductions to Object Oriented Programming methods, DATA step programs, user-defined methods, predefined packages, and threaded processing.

Clear, practical IPSAS guidance, explanation, and examples Interpretation and Application of IPSAS provides practical guidance on the implementation and application of the International Public Sector Accounting Standards. This book brings readers up to date on the standards, and describes their proper interpretation and real-world application. Examples and mini-case studies clarify the standards' roles throughout, giving readers a better understanding of complex processes, especially where the IPSAS deviate from IFRS. Readers also gain insight into smoothly navigating the transition for a public sector entity, which is moving to either IPSAS under accrual basis of accounting or to cash accounting IPSAS, plus an overview of IPSAS adoption status and methods around the world. Global public sector accounting is highly diversified, resulting in ongoing moves to harmonise standards worldwide. The IPSAS are international standards that largely follow the IFRS model, but differ in some key areas and include standards in places where IFRS has none. This book provides complete guidance to IPSAS, with clear explanation and expert insight. Understand the meaning and role of each standard Apply the standards to real-world scenarios Manage the process of transition to IPSAS These standards are meant to be followed by all public sector entities, including national and regional governments and local authorities. They've been adopted by the UN, NATO, the European Commission, and others, and either have been or soon will be adopted in Malaysia, Switzerland, Spain, and more.

Provides a point of entry for understanding the basics of the SAS Intelligence Platform. It discusses the benefits of the SAS Intelligence Platform to businesses, describes the architecture, and provides an overview of each software component. This document can be used alone or as an introduction to the deployment and administration guides.

Aimed at econometricians who have completed at least one course in time series modeling, Multiple Time Series Modeling Using the SAS VARMAX Procedure will teach you the time series analytical possibilities that SAS offers today. Estimations of model parameters are now performed in a split second. For this reason, working through the identifications phase to find the correct model is unnecessary. Instead, several competing models can be estimated, and their fit can be compared instantaneously.

Consequently, for time series analysis, most of the Box and Jenkins analysis process for univariate series is now obsolete. The former days of looking at cross-correlations and pre-whitening are over, because distributed lag models are easily fitted by an automatic lag identification method. The same goes for bivariate and even multivariate models, for which PROC VARMAX models are automatically fitted. For these models, other interesting variations arise: Subjects like Granger causality testing, feedback, equilibrium, cointegration, and error correction are easily addressed by PROC VARMAX.

One problem with multivariate modeling is that it includes many parameters, making parameterizations unstable. This instability can be compensated for by application of Bayesian methods, which are also incorporated in PROC VARMAX. Volatility modeling has now become a standard part of time series modeling, because of the popularity of GARCH models. Both univariate and multivariate GARCH models are supported by PROC VARMAX. This feature is especially interesting for financial analytics in which risk is a focus.

This book teaches with examples. Readers who are analyzing a time series for the first time will find PROC VARMAX easy to use; readers who know more advanced theoretical time series models will discover that PROC VARMAX is a useful tool for advanced model building.

Master Data Analytics Hands-On by Solving Fascinating Problems You’ll Actually Enjoy! Harvard Business Review recently called data science “The Sexiest Job of the 21st Century.” It’s not just sexy: For millions of managers, analysts, and students who need to solve real business problems, it’s indispensable. Unfortunately, there’s been nothing easy about learning data science–until now. Getting Started with Data Science takes its inspiration from worldwide best-sellers like Freakonomics and Malcolm Gladwell’s Outliers: It teaches through a powerful narrative packed with unforgettable stories. Murtaza Haider offers informative, jargon-free coverage of basic theory and technique, backed with plenty of vivid examples and hands-on practice opportunities. Everything’s software and platform agnostic, so you can learn data science whether you work with R, Stata, SPSS, or SAS. Best of all, Haider teaches a crucial skillset most data science books ignore: how to tell powerful stories using graphics and tables. Every chapter is built around real research challenges, so you’ll always know why you’re doing what you’re doing. You’ll master data science by answering fascinating questions, such as: • Are religious individuals more or less likely to have extramarital affairs? • Do attractive professors get better teaching evaluations? • Does the higher price of cigarettes deter smoking? • What determines housing prices more: lot size or the number of bedrooms? • How do teenagers and older people differ in the way they use social media? • Who is more likely to use online dating services? • Why do some purchase iPhones and others Blackberry devices? • Does the presence of children influence a family’s spending on alcohol? For each problem, you’ll walk through defining your question and the answers you’ll need; exploring how others have approached similar challenges; selecting your data and methods; generating your statistics; organizing your report; and telling your story. Throughout, the focus is squarely on what matters most: transforming data into insights that are clear, accurate, and can be acted upon.

Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information includes retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code. The reference information includes statements, dictionary components, and system options.

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way. Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS. Understand core analytic techniques that work with SQL and Excel Ensure your analytic approach gets you the results you need Design and perform your analysis using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.

Students and instructors of statistics courses using SAS University Edition will welcome this book. Learning fundamental statistics is essential to solving problems with SAS. Essential Statistics Using SAS University Edition demonstrates how to use SAS University Edition to apply a variety of statistical methodologies, from the simple to the not-so-simple, to a range of data sets. Learn how to apply the appropriate statistical method to answer a particular question about a data set, and correctly interpret the numerical results that you obtain. SAS University Edition users who are new to SAS or who need a refresher course will benefit from the statistics overview and topics, such as multiple linear regression, logistic regression, and Poisson regression.

Get the tools you need to use SAS® in clinical trial design!

Unique and multifaceted, Modern Approaches to Clinical Trials Using SAS: Classical, Adaptive, and Bayesian Methods, edited by Sandeep M. Menon and Richard C. Zink, thoroughly covers several domains of modern clinical trial design: classical, group sequential, adaptive, and Bayesian methods that are applicable to and widely used in various phases of pharmaceutical development. Written for biostatisticians, pharmacometricians, clinical developers, and statistical programmers involved in the design, analysis, and interpretation of clinical trials, as well as students in graduate and postgraduate programs in statistics or biostatistics, the book touches on a wide variety of topics, including dose-response and dose-escalation designs; sequential methods to stop trials early for overwhelming efficacy, safety, or futility; Bayesian designs that incorporate historical data; adaptive sample size re-estimation; adaptive randomization to allocate subjects to more effective treatments; and population enrichment designs. Methods are illustrated using clinical trials from diverse therapeutic areas, including dermatology, endocrinology, infectious disease, neurology, oncology, and rheumatology. Individual chapters are authored by renowned contributors, experts, and key opinion leaders from the pharmaceutical/medical device industry or academia. Numerous real-world examples and sample SAS code enable users to readily apply novel clinical trial design and analysis methodologies in practice.

Contains the complete reference for all Base SAS procedures. Provides information about what each procedure does and, if relevant, the kind of output that it produces.

This guide explains how to apply health economic evaluation techniques to both clinical trial and non-clinical trial data. Through a simple, applied approach using examples and SAS software, the book helps statisticians and researchers in health economics assess cost-effectiveness. It covers trial design, case report form design, quality of life measures, sample sizes, submissions to regulatory authorities for reimbursement, Markov models, cohort models, and decision trees. Examples and case studies are provided at the end of each chapter.