• Computers

The Essential PROC SQL Handbook for SAS Users


Author: Katherine Prairie
Publisher: SAS Institute
ISBN: 1590475712
Category: Computers
Page: 572
View: 4475
Written in an easy-to-use, logical format, this comprehensive reference focuses on the functionality of the procedure as well as the accomplishment of common tasks using PROC SQL, enabling readers to quickly develop and enhance their SQL skills. Features include more than 300 examples of PROC SQL code, plus queries and diagrams.

    • Computers

PROC SQL by Example

Using SQL Within SAS
Author: Howard Schreier
Publisher: SAS Institute
ISBN: 1599948834
Category: Computers
Page: 296
View: 1780

    • Mathematics

PROC SQL: Beyond the Basics Using SAS, Second Edition


Author: Kirk Paul Lafler
Publisher: SAS Institute
ISBN: 1612907342
Category: Mathematics
Page: 400
View: 343
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.

    • Computers

The Little SAS Book

A Primer, Fifth Edition
Author: Lora D. Delwiche,Susan J. Slaughter
Publisher: SAS Institute
ISBN: 1612904009
Category: Computers
Page: 376
View: 4481
A classic that just keeps getting better, The Little SAS Book is essential for anyone learning SAS programming. Lora Delwiche and Susan Slaughter offer a user-friendly approach so readers can quickly and easily learn the most commonly used features of the SAS language. Each topic is presented in a self-contained two-page layout complete with examples and graphics. 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 book is a great tool for users of SAS 9.4 as well. 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. This book is part of the SAS Press program.

    • Mathematics

Handbook of SAS® DATA Step Programming


Author: Arthur Li
Publisher: CRC Press
ISBN: 9781466552388
Category: Mathematics
Page: 275
View: 8870
To write an accomplished program in the DATA step of SAS®, programmers must understand programming logic and know how to implement and even create their own programming algorithm. Handbook of SAS® DATA Step Programming shows readers how best to manage and manipulate data by using the DATA step. The book helps novices avoid common mistakes resulting from a lack of understanding fundamental and unique SAS programming concepts. It explains that learning syntax does not solve all problems; rather, a thorough comprehension of SAS processing is needed for successful programming. The author also guides readers through a programming task. In most of the examples, the author first presents strategies and steps for solving the problem, then offers a solution, and finally gives a more detailed explanation of the solution. Understanding the DATA steps, particularly the program data vector (PDV), is critical to proper data manipulation and management in SAS. This book helps SAS programmers thoroughly grasp the concept of DATA step processing and write accurate programs in the DATA step. Numerous supporting materials, including data sets and programs used in the text, are available on the book’s CRC Press web page.

    • Mathematics

Carpenter's Guide to Innovative SAS Techniques


Author: Art Carpenter
Publisher: SAS Institute
ISBN: 1612902022
Category: Mathematics
Page: 570
View: 7348
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.

    • Computers

Basic Statistics Using SAS Enterprise Guide

A Primer
Author: Geoff Der,Brian Everitt
Publisher: SAS Institute
ISBN: 1599947153
Category: Computers
Page: 240
View: 6326
This example-rich guide shows you how to conduct a wide range of statistical analyses with no SAS programming required. For each analysis, one or more real data sets, a brief introduction of the technique, and a clear explanation of the SAS Enterprise Guide output are provided.

    • Computers

Learning SAS by Example

A Programmer's Guide, Second Edition
Author: Ron Cody
Publisher: SAS Institute
ISBN: 1635266564
Category: Computers
Page: 536
View: 1313
Learn to program SAS by example! Learning SAS by Example, A Programmer’s Guide, Second Edition, teaches SAS programming from very basic concepts to more advanced topics. Because most programmers prefer examples rather than reference-type syntax, this book uses short examples to explain each topic. The second edition has brought this classic book on SAS programming up to the latest SAS version, with new chapters that cover topics such as PROC SGPLOT and Perl regular expressions. This book belongs on the shelf (or e-book reader) of anyone who programs in SAS, from those with little programming experience who want to learn SAS to intermediate and even advanced SAS programmers who want to learn new techniques or identify new ways to accomplish existing tasks. 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 Getting started with the SAS macro language Leveraging PROC SQL Generating high-quality graphics Using advanced features of user-defined formats and informats Restructuring SAS data sets Working with multiple observations per subject Getting started with Perl regular expressions You can test your knowledge and hone your skills by solving the problems at the end of each chapter.

    • Computers

The Essential Guide to SAS Dates and Times


Author: Derek P. Morgan
Publisher: SAS Institute
ISBN: 1599941066
Category: Computers
Page: 172
View: 5145
Why does SAS use January 1, 1960, as its arbitrary reference date? How do you convert a value such as 27 January 2003 into SAS dates? You'll find the answers to these questions and much more in Derek Morgan's Essential Guide to SAS Dates and Times, which makes it easy to understand how to use and manipulate dates, times, and datetimes in SAS. Novice-to-intermediate users will find the clear, task-focused examples and explanations of formats and functions invaluable; experienced users will appreciate discussions of topics such as intervals and international date and time formats. Included is a bonus "Quick Reference Guide" listing all the formats (with examples) on one handy page. This book is part of the SAS Press program.

    • Computers

SAS 9.4 SQL Procedure User's Guide


Author: SAS Institute
Publisher: SAS Institute
ISBN: 1612906532
Category: Computers
Page: 480
View: 5125
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.

    • Computers

An Introduction to SAS University Edition


Author: Ron Cody
Publisher: SAS Institute
ISBN: 1629600075
Category: Computers
Page: 366
View: 9406
Get up and running with the SAS University Edition using Ron Cody’s easy-to-follow, step-by-step guide. Aimed at beginners who have downloaded the free SAS University Edition and want to either use the point-and-click interactive environment of SAS Studio, or who want to write their own SAS programs, or both, An Introduction to SAS University Edition, begins by showing you how to obtain the SAS University Edition, and how you can run SAS on a PC or Macintosh computer. The first part of the book shows you how to perform basic tasks, such as producing a report, summarizing data, producing charts and graphs, and using the SAS Studio built-in tasks. The first part also describes how you can perform basic statistical tests using the interactive point-and-click environment. The second part of the book shows you how to write your own SAS programs, and how to use SAS procedures to perform a variety of tasks. This part of the book also explains how to read data from a variety of sources: text files, Excel workbooks, and CSV files. In order to get familiar with the SAS Studio environment, this book also shows you how to access dozens of interesting data sets that are included with the product. Loading data files into SAS University Edition? Click here for more information.

    • Mathematics

SAS Functions by Example, Second Edition


Author: Ron Cody, EdD
Publisher: SAS Institute
ISBN: 9781607643647
Category: Mathematics
Page: 472
View: 726
Fully updated for SAS 9.2, Ron Cody's SAS Functions by Example, Second Edition, is a must-have reference for anyone who programs in Base SAS. With the addition of functions new to SAS 9.2, this comprehensive reference manual now includes more than 200 functions, including new character, date and time, distance, probability, sort, and special functions. This new edition also contains more examples for existing functions and more details concerning optional arguments. Like the first edition, the new edition also includes a list of SAS programs, an alphabetic list of all the functions in the book, and a comprehensive index of functions and tasks. Beginning and experienced SAS users will benefit from this useful reference guide to SAS functions. This book is part of the SAS Press program.

    • Computers

SAS Programming for Enterprise Guide Users, Second Edition


Author: Neil Constable
Publisher: SAS Institute
ISBN: 9781607645276
Category: Computers
Page: 308
View: 3385
New and updated for SAS Enterprise Guide 4.2, this pragmatic, example-driven book demonstrates how programmers can use SAS code to enhance the capabilities of SAS Enterprise Guide.

    • Computers

The Little SAS Book for Enterprise Guide 4.2


Author: Susan J. Slaughter,Lora D. Delwiche
Publisher: SAS Press
ISBN: 9781599947266
Category: Computers
Page: 371
View: 8275
The authors help programmers quickly become familiar with the SAS Enterprise Guide point-and-click environment. A series of carefully designed tutorials helps readers master the basics of the tasks they will want to do most frequently.

    • Computers

Mastering the SAS DS2 Procedure

Advanced Data-Wrangling Techniques, Second Edition
Author: Mark Jordan
Publisher: SAS Institute
ISBN: 1635266068
Category: Computers
Page: 192
View: 1461
Enhance your SAS data-wrangling skills with high-precision and parallel data manipulation using the DS2 programming language. Now in its second edition, this book addresses the 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 covers 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. Here's what's new in this edition: how to significantly improve performance by using the new SAS Viya architecture with its SAS Cloud Analytic Services (CAS) how to declare private variables and methods in a package the new PROC DSTODS2 the PCRXFIND and PCRXREPLACE packages While working though 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. This book is part of the SAS Press Series.

    • Mathematics

Cody's Data Cleaning Techniques Using SAS, Second Edition


Author: Ron Cody
Publisher: SAS Institute
ISBN: 1629597732
Category: Mathematics
Page: 268
View: 2921
Thoroughly updated for SAS 9, Cody's Data Cleaning Techniques Using SAS, Second Edition, addresses tasks that nearly every SAS programmer needs to do - that is, make sure that data errors are located and corrected. Written in Ron Cody's signature informal, tutorial style, this book develops and demonstrates data cleaning programs and macros that you can use as written or modify for your own special data cleaning needs. Each topic is developed through specific examples, and every program and macro is explained in detail.

    • Mathematics

Sharpening Your Advanced SAS Skills


Author: Sunil Gupta
Publisher: CRC Press
ISBN: 1498766900
Category: Mathematics
Page: 156
View: 8777
Sharpening Your Advanced SAS® Skills presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. Drawing on his more than 20 years’ experience of SAS programming in the pharmaceutical industry, the author provides a unique approach that empowers both advanced programmers who need a quick refresher and programmers interested in learning new techniques. The book helps you easily search for key points by summarizing and differentiating the syntax between similar SAS statements and options. Each chapter begins with an overview so you can quickly locate the detailed examples and syntax. The basic syntax, expected data, and descriptions are organized in summary tables to facilitate better memory recall. General rules list common points about similar statements or options. Real-world examples of SAS programs and code statements are line numbered with references, such as SAS papers and websites, for more detailed explanations. The text also includes end-of-chapter questions to reinforce your knowledge of the topics and prepare you for the advanced SAS certification exam. In addition, the author’s website offers mindmaps and process flowcharts that connect concepts and relationships.

    • Computers

SAS Certification Prep Guide

Base Programming for SAS9, Fourth Edition
Author: SAS Institute
Publisher: SAS Institute
ISBN: 1635264685
Category: Computers
Page: 582
View: 8481
Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS 9 exam will find this guide to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam. Now in its fourth edition, the guide has been extensively updated, and revised to streamline explanations. 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. The chapter quizzes have been thoroughly updated and full solutions are included at the back of the book. In addition, links are provided to the exam objectives, practice exams, and other helpful resources, such as the updated Base SAS glossary and an expanded collection of practice data sets. Content updates are available here.

Blue Fire


Author: Katherine Prairie
Publisher: N.A
ISBN: 9780994937759
Category:
Page: 368
View: 6436
Tanzanite, a rare blue gem born in fire and revealed by lightning, is found only in the Merelani Hills of Tanzania. But now the death of a gem smuggler points to another possibility. A South American mine owned by Tabitha Metals may hold the find of a century. But why is it kept hidden from the world? Geologist Brian Graham can draw only one conclusion: the mine's untraceable wealth is used to fund terrorism. And he must reveal the truth. Brian heads to Colombia to check out mines there while his geologist daughter Alex and Tanzanian miner Mosi Ongeti start in Brazil. But their daring plan ends with a gunshot, and they are now pursued by the henchmen of a sinister, powerful arms dealer. In a high-stakes race across two continents, Alex fights to expose the mine before the man behind Tabitha Metals can stop her.

    • Business & Economics

Credit Risk Scorecards

Developing and Implementing Intelligent Credit Scoring
Author: Naeem Siddiqi
Publisher: John Wiley & Sons
ISBN: 1118429168
Category: Business & Economics
Page: 208
View: 5795
Praise for Credit Risk Scorecards "Scorecard development is important to retail financial services in terms of credit risk management, Basel II compliance, and marketing of credit products. Credit Risk Scorecards provides insight into professional practices in different stages of credit scorecard development, such as model building, validation, and implementation. The book should be compulsory reading for modern credit risk managers." —Michael C. S. Wong Associate Professor of Finance, City University of Hong Kong Hong Kong Regional Director, Global Association of Risk Professionals "Siddiqi offers a practical, step-by-step guide for developing and implementing successful credit scorecards. He relays the key steps in an ordered and simple-to-follow fashion. A 'must read' for anyone managing the development of a scorecard." —Jonathan G. Baum Chief Risk Officer, GE Consumer Finance, Europe "A comprehensive guide, not only for scorecard specialists but for all consumer credit professionals. The book provides the A-to-Z of scorecard development, implementation, and monitoring processes. This is an important read for all consumer-lending practitioners." —Satinder Ahluwalia Vice President and Head-Retail Credit, Mashreqbank, UAE "This practical text provides a strong foundation in the technical issues involved in building credit scoring models. This book will become required reading for all those working in this area." —J. Michael Hardin, PhD Professor of StatisticsDepartment of Information Systems, Statistics, and Management ScienceDirector, Institute of Business Intelligence "Mr. Siddiqi has captured the true essence of the credit risk practitioner's primary tool, the predictive scorecard. He has combined both art and science in demonstrating the critical advantages that scorecards achieve when employed in marketing, acquisition, account management, and recoveries. This text should be part of every risk manager's library." —Stephen D. Morris Director, Credit Risk, ING Bank of Canada