Product Description
Learn how to build real-world applications using SAS/AF software with this detailed reference guide. Application developers will find the information they need to build applications using the BUILD environment and to run them using the AF environment. This guide provides complete descriptions of all the essential features that can be used with the BUILD procedure, including statements, options, windows, and commands. Except for the FRAME entry and its components, which are documented separately, this guide covers all entry types that can be built with SAS/AF software. This guide is designed for SAS/AF application programmers who have some knowledge of SAS. ... Read more

Product Description
This user's guide explains how to use the XML engine in order to export a SAS data set as an XML document and to import an external XML document as a SAS data set. This title is intended for users who have previous experience with SAS, have knowledge of XML, and require data access to and from XML markup. ... Read more

Product Description
This detailed reference guide for SAS/AF software provides completedescriptions of all statements, options, windows, and commands that canbe used with the BUILD procedure.Application developers will find theinformation they need to use the BUILD environment for buildingapplications and the AF environment for running them.This title coversall entry types that can be built with SAS/AF software except for theFRAME entry and the components associated with it, which are documentedseparately. This title is designed for SAS/AF application programmers whohave some knowledge of the SAS System. This title is available for purchaseas a hardcopy or digital book, or in the SAS OnlineDoc CD-ROM with PDFfiles. The HTML version of SAS OnlineDoc CD-ROM is shipped free withVersion 8.

Supports releases 8.00 and higher of SAS software. ... Read more

Product Description
The ETL process consists of all the steps necessary to extract data from different locations, transform raw operational data into consistent, high-quality business data, and load the data into a data warehouse. SAS provides all of this with the addition of an easy-to-use, metadata-driven warehouse management environment. This manual explains how to use SAS ETL Studio to specify metadata for sources, such as tables in an operational system; specify metadata for targets--the tables and other data stores in a data warehouse; and create jobs that specify how data is extracted, transformed, and loaded from sources to targets. This manual also summarizes how to set up servers, libraries, and other resources that SAS ETL Studio requires. A data warehouse for a fictional company, Orion Star Sports & Outdoors, is used to illustrate these tasks. The audience for this manual is users who are responsible for implementing data warehouses and who have a working knowledge of Base SAS softwar ... Read more

Product Description
This title introduces you to the SAS Open Metadata Architecture and the SASOpen Metadata Interface by walking you through the steps of setting up aSAS Metadata Server and creating a metadata repository for a simple projectin the Windows NT operating environment. ... Read more

Product Description
Are you ready to integrate your XML documents with your SAS applications? This user's guide explains how to use the XML engine in order to export a SAS data set as an XML document and to import an external XML document as a SAS data set. This title provides lots of examples to illustrate how to import and export XML documents; explains the XML physical structure that the XML engine requires in order to successfully import an XML document; provides explanations and several examples of how to import an XML document that does not conform to the required XML physical structure; introduces XML Mapper, which is a Java application that assists you in creating and modifying XMLMaps, and XMLMap Manager, which provides centralized management of XMLMaps as metadata objects; explains how you can use tagsets in order to customize an exported XML document; provides complete reference for the LIBNAME statement for the XML engine as well as for the element descriptions for the XMLMaps syntax. This title is also available online. This title is intended for users who have previous experience with SAS, have knowledge of XML, and require data access to and from XML markup.

Supports releases 9.1 and higher of SAS software. ... Read more

Product Description
Base SAS software supports Structured Query Language (SQL), the ANSI standard and widely used language that enables you to create, retrieve, and update database information. This title is your introductory, task-oriented resource for SQL as implemented through the SAS SQL procedure. With this title, you will learn the basics of using PROC SQL, including 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. Additionally, detailed examples show you how to use PROC SQL to solve real-world problems, such as computing a weighted average, expanding hierarchical data in a table, creating a summary report, updating a table with values from another table, and using PROC SQL tables in other SAS programs. This title is also available online. This title is intended for users with a working knowledge of SAS programming. No knowledge of SQL or relational databases is assumed.

Supports releases 9.1 and higher of SAS software. ... Read more

Customer Reviews (1)

Save your money!
Save your money and just use the SAS online documentation. This title of this book says that it is a user's guide (if I am not mistaken, it is simply a print version of the online documentation), and it certainly reads like one, i.e. dry and boring. If you are a beginner, you will either fall asleep or be so confused. If you are an intermediate SAS programmer looking for a reference, just use the online documentation, as suggested earlier. ... Read more

Product Description
Now it's easier than ever to customize your reports using the REPORT procedure! The REPORT language has evolved into a more sophisticated tool with a user-friendly interface that makes it easier for you to create the reports you need. Complete reference documentation for both the windowing and nonwindowing environments is now in one book. This book assumes you are familiar with the ideas of SAS libraries, data sets, and formats. With the exception of the last chapter, which describes in detail how PROC REPORT builds a report, this same reference information is also available online with Release 6.11 and later releases of base SAS software. ... Read more

Product Description
SAS(R) Management Console is a Java application that provides a single point of control for managing resources that are used throughout theIntelligence Value Chain. ... Read more

Product Description
This title explains how to use the SAS Open Metadata Interface to create, query, update, and delete metadata about application elements. It also discusses change management processes, how to create and query dependent repositories, and how to perform other repository maintenance tasks. Usage scenarios explain how to create metadata to represent the most frequently used application elements. ... Read more

Product Description
This title describes techniques newly available in SAS to find global optima using intelligent search techniques that are modeled after biological or physical processes. These techniques are flexible and robust, and are applicable to problems where traditional calculus-based methods do not apply or are too difficult or complicated. With these procedures, you can solve combinatorial problems, nonlinear function optimization problems, mixed integer problems, sequencing problems, and multiple objective Pareto optimization problems. This title serves as the primary documentation for the new 9.1 Genetic Algorithms procedure, which utilizes genetic algorithms to find optimal solutions to a variety of problems. This title is for end users who have experience with SAS and some familiarity with mathematical optimization techniques. ... Read more

Product Description
This book is an instructional reference guide for SAS/INSIGHT software, an interactive, easy-to-use tool for data exploration and analysis. The first section of the book describes how to perform common data analysis tasks using SAS/INSIGHT software. Such tasks include point identification, brushing, three-dimensional rotation, distribution analysis, curve-fitting, multiple regression, ANOVA, logistic regression, transformations, and principal component analysis. The second section of the book provides complete reference to graphical and analytical features of the software. These features include the data window, bar charts, box plots, scatter plots, rotating plots, distribution analysis, multivariate analysis, and the generalized linear model. ... Read more

Product Description
Now it's easy to manage data and create reports without writing any SAS code using SAS Learning Edition 2.0*! Step-by-step instructions and numerous examples show you how you can access the power of SAS by using the SAS Enterprise Guide point-and-click interface or by writing and modifying SAS code through the SAS Program Editor to produce simple and complex reports.

Topics addressed include: SAS Learning Edition 2.0 basics, using decision tree tables to select analysis and reporting tasks, preparing data and producing reports for distribution, creating charts and graphs, and writing and modifying code to produce custom reports and graphs.

Business professionals and students seeking to develop quick, reliable output-without having to learn detailed syntax-will benefit from this nontechnical guide. ... Read more

Customer Reviews (1)

Superb book to learn SAS Enterprise Guide
A perfect guide for SAS reporting. This book contains a huge collection of tips, techniques,and examples which are very useful in learningSAS Enterprise Guide. Provides good examples on how reporting can be made simple and easy with the point and click interface avaiable in the SAS EG product instead of writing complex SAS code. ... Read more

Product Description
Discover how you can choose from among multiple strategies to easily move or access SAS files across operating environments. In this guide you learn how to use CEDA, the preferred strategy for file access across a network. CEDA enables you to transparently read a network-mounted SAS file from any directory-based operating environment that runs SAS Version 8 or later, regardless of the file format of the SAS file; dynamically convert data between the native formats of the source and target operating environments; and change the SAS file to the format of the accessing operating environment. You can also learn how to use the traditional method of moving a SAS file across operating environments by creating a transport file that will be restored at the target machine to transfer across a network. PROC CPORT, PROC CIMPORT, PROC COPY, and the XPORT engine are used to accomplish a traditional move operation. Starting in SAS 9, another method of moving a SAS data set across operating environments is to use the XML engine to convert the file to an XML document. At the target machine, the data can be restored as a SAS data set for continued access. The information presented in this title does not apply to SAS releases prior to 6.07. ... Read more

Product Description
This comprehensive Base SAS reference manual provides you with a complete selection of reference entries for individual elements of the SAS language in an alphabetized, encyclopedia format. This title is intended for users who have previous experience with SAS or who have at least an intermediate level of expertise with another programming language. This title is also available free online from SAS Publishing. ... Read more

Product Description
Overwhelmed by too much information? Left hanging without quite enough direction? If you answer to these questions is "yes," you will find this book is just right for getting an easy, yet complete introduction to using SAS software. This task-oriented handbook presents SAS software in a format that is inviting and convenient. Each task is presented in a self-contained two-page layout complete with examples, graphics, and cross-references to other SAS software documentation. Topics range from concepts of the SAS language to using basic statistical procedures and debugging programs. The modular and concise format makes this an ideal tutorial for concentrated study and a great quick reference for particular tasks. Beginning and elementary users will be pleasantly surprised by this unusually appealing approach to mastering basic programming task such as inputting data, modifying and combining data sets, and summarizing and presenting data with the MEANS, PLOT, FREQ, and PRINT procedures. The beginner will also learn about more advanced topics such as arrays, RETAIN statements, and transport data sets.

Supports releases 6.06 and higher of SAS software. ... Read more

Customer Reviews (32)

excellent reference for beginners and those needing a refresher
This book is concise and has many of the key ideas that beginning SAS programmers need. It is a good reference even for advanced SAS programmers but does not go far beyond the basics. If you use SAS regularly this will not have enough information for you. However, it is the quickest way to find out how to do something basic that you either have never done or forgot how to do. I only have the 2nd edition, so I can't comment on any changes that may be incorporated in the third edition.

The Little SAS Book : A Primer, Second Edition
I have used SAS for over 25 years on various platforms. The new Learning Edition is perfect for anyone doing relatively straight forward statistical tasks on a regular PC. It is easy to use, and results can be stred is easily reuseable forms. This book, by Loa Delwiche, will guide an old hand or new comer through use of the program quickly and painlessly.

Great SAS overview!
This book gives a nice review of the key SAS topics. The information is very condensed, very well structured and organized. It begins with the basics and goes deeper, so this book is perfect for people looking for a quick way to get started with SAS. You'll probably need a day to read it through to get a pretty good idea what SAS is about. Of course, this format has some drawbacks. Typically you read this book faster then you can digest the information. So even if you can finish the book in a few hours, it will still take days to understand the topics. Most subjects include one example. That gives you an idea, but if you have your own problem and want to find a similar example, you'll probably be out of luck. Since most of the examples are quick few liners, the book doesn't really teach you how to approach a complex data crunching projects. It would help a lot if you already know some computer language, otherwise, the book may look too fast pace for you.

Also, despite the high density of the information, the authors managed to keep the language easy to read.

Still Useful Even w/ SAS Experience...
As the title indicates, this book is a "primer" and ought to be regarded as such, although the experienced user (of course, level of experience is relative) can still expect to derive some utility from Delwiche & Slaughter's concise and well-written book.The authors' emphasis on & discussion of SAS's "Built-in Loop" (Section 1.4) is worth it alone --- this simple point is often glossed over, although its importance can't be stressed enough.So toward that end:"DATA steps execute line by line and observation by observation."
In short, this book ought to belong on the shelf of every SAS user --- novice and expert alike.

SAS APPEAL

SAS APPEAL
One of the best introductions to SAS, the "little purple book" is now in its 3rd edition (November 2003; ISBN: = 1590473337).Compared with the previous version (this one)," the 3rd edition includes more information on preparing reports and tables, and exporting data.However, the basic format and organization is the same.

This book is organized into 8 chapters, with six appendices, and an index.The overall organization is clear-- one topic leads clearly to the next (contrast this with the overly concise "Getting Started with the SQL Procedure," also by SAS). The book clearly assumes no previous SAS knowledge, although covering operating systems (e.g., Windows, your local workstation or mainframe) is beyond the book's scope.Previous experience with any data entry, data management, or programming will be very helpful, but is not essential. Each chapter is organized into two-page topics (these range from 7 topics in the MACRO chapter to 20 in the overly long data entry chapter) with introductory paragraphs, examples that include a small data set, and programming related to the topic.Programming language related to the new topic is shaded to distinguish it from material already covered or otherwise irrelevant.Because of the mini-data sets for each topic, you don't have to keep returning to datasets presented at the beginning only (as you do with some introductory texts).The reason for using the language, the data, the example, and the output are all there on the 2 facing pages; it's very easy to use.

In 217 well-written pages, the book advances from the very introductory (e.g., every SAS line ends with a semicolon; think of columns as variables, and rows as observations) to techniques (e.g., the chapter on MACROS) and programming "tricks" useful to those with years of experience (the too-brief chapter on debugging programs, the section on the always difficult MERGE statement).This is the challenge of an introductory book:It needs to teach the basics, but not so basic that one can finish the entire book in a couple of hours.Delwiche and Slaughter handle this task superbly. Chapter 1, for example, explains basic SAS concepts (the database, the data step, procedures, viewing and printing output), and a few pages on SAS for Windows.(The authors occasionally refer to SAS for Windows ("PC SAS"); this is valuable for those who have this software but otherwise extraneous.) Still, after nearly 15 years of SAS experience, I turn to this book when I want a concise yet easily understood explanation of something I may have not used for awhile.After mastering this book, I recommend that users follow it with the somewhat more advanced "SAS Programming for Researchers and Social Scientists" (Paul Spector) and/or "Cody's Data Cleaning Techniques (Ron Cody).

Chapters are as follows (I've added a sample topic in parentheses after each chapter title):

1. Getting Started Using SAS Software ("The Two Parts of a SAS Program")
2. Getting Your Data into the SAS System ("Reading Raw Data...")
3. Working with Your Data("Subsetting Your Data")
4. Sorting, Printing, and Summarizing Your Data("Summarizing Your Rata with PROC MEANS")
5. Modifying and Combining SAS Data Sets(Combining Data Sets Using a One-to-Many Match Merge")
6. Writing Flexible Code with the SAS Macro Facility("Macro Concepts")
7. Using Basic Statistical Procedures("Using PROC REG for Simple Regression Analysis")
8. Debugging Your SAS Programs("DATA Step Produces Wrong Results but No Error Message")

The book's main problem is Chapter 2. The lengthy material on inputting data will be irrelevant for most students, as datasets are often already prepared.Still, because one may sometimes need to create a dataset, the chapter is useful. In addition, chapter 8, doesn't contain include enough on error detection and debugging programs, an extremely important SAS skill that helps one detect and distinguish programming and dataset errors. Also the Appendix on resources, "Where to Go from Here," mentions SAS Institute published books only, although this is partly due to the paucity of well written SAS books by independent authors when the second edition came out in 1998 (compared with today). Overall, while this much-loved book is much loved by those who took their first SAS steps with it.I recommend the new edition (3rd) edition; it has more topics and is more current, for only slightly more money. ... Read more

Product Description
This newly updated second edition of Michael A. Raithel's esteemed Tuning SAS Applications in the MVS Environment is the definitive book for tuning SAS applications that run on mainframe computers under the MVS, OS/390, and z/OS operating systems. Tuning SAS Applications in the OS/390 and z/OS Environments details the many tools and methodologies SAS programmers can use to reduce computer processing overhead, thus making their applications perform better and reducing computer charge-back costs. SAS programmers experienced in other operating environments, as well as newer SAS users, will increase their understanding of OS/390 system processes, performance measures, and operating system features. In addition, key OS/390 concepts are highlighted, including the three types of work that run on OS/390; OS/390 memory management; and hiperspaces. ... Read more

Customer Reviews (1)

The only help for SAS on MVS
You are coming to MVS shop with already set SAS/ETL process. They are using number of flat files with up to 60million records per fileandSAS data sets withup to 10 million observations. Flat fileshave been growing around 150k records per month. Some jobs take more than 1.5 hour of CPU timeto run and some simply abend with storage problems related to working files.In cases like that, trying to solve your problems with improved SAS coding might not work andyou have to looka bit further to avoid disaster.
Michael's books will guide you through SAS options - how to display all the defaults and how to change them. Will explain why you would make such a choices as well. Will tell you, how to calculate total memory needed to hold a data set's buffers andhow to use BUFNOto reduce EXCP.SASFILE, COMPRESS are coming with strategies, explaining when to use them and when not to. One whole chapter is devoted to indexes and another to efficient processing of sequential data set, including VSAM. Some more esoteric options like using hyperspace or reduction oftape mount wait time are explained as well. You will be forced to dig a bit more into OS/390 memorymanagement concepts.
This not exactly a book every SAS programmer must have. But if you keep running SAS jobs on the mainframe and you are dealing with lots of data you will benefit from it tremendously
... Read more