The Essential PROC SQL Handbook for SAS Users

DOWNLOAD NOW »

Author: Katherine Prairie

Publisher: SAS Institute

ISBN: 1590475712

Category: Computers

Page: 572

View: 5582

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.

PROC SQL by Example

Using SQL Within SAS

DOWNLOAD NOW »

Author: Howard Schreier

Publisher: SAS Institute

ISBN: 1599948834

Category: Computers

Page: 296

View: 6798

PROC SQL: Beyond the Basics Using SAS, Second Edition

DOWNLOAD NOW »

Author: Kirk Paul Lafler

Publisher: SAS Institute

ISBN: 1612907342

Category: Mathematics

Page: 400

View: 9405

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.

Handbook of SAS® DATA Step Programming

DOWNLOAD NOW »

Author: Arthur Li

Publisher: CRC Press

ISBN: 9781466552388

Category: Mathematics

Page: 275

View: 1283

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.

The Little SAS Book

A Primer, Fifth Edition

DOWNLOAD NOW »

Author: Lora D. Delwiche,Susan J. Slaughter

Publisher: SAS Institute

ISBN: 1612904009

Category: Computers

Page: 376

View: 4427

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.

Basic Statistics Using SAS Enterprise Guide

A Primer

DOWNLOAD NOW »

Author: Geoff Der,Brian Everitt

Publisher: SAS Institute

ISBN: 1599947153

Category: Computers

Page: 240

View: 5473

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.

Carpenter's Guide to Innovative SAS Techniques

DOWNLOAD NOW »

Author: Art Carpenter

Publisher: SAS Institute

ISBN: 1612902022

Category: Mathematics

Page: 570

View: 9701

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.

SAS Hash Object Programming Made Easy

DOWNLOAD NOW »

Author: Michele M. Burlew

Publisher: SAS Institute

ISBN: 1612900984

Category: Mathematics

Page: 208

View: 545

Hash objects, an efficient look-up tool in the SAS DATA step, are object-oriented programming structures that function differently from traditional SAS language statements. Michele Burlew's SAS Hash Object Programming Made Easy shows readers how to use these powerful features, which they can program to quickly look up and manage data and to conserve computing resources. SAS provides various look-up techniques, and hash objects are among the newest, so therefore many users may not have yet used them. Because the examples presented vary in complexity, SAS Hash Object Programming Made Easy is useful to SAS users of all experience levels, from novice programmer to advanced programmer. Novice programmers can adapt some of the simpler hash programming techniques as they develop their SAS programming skills. This book helps more experienced programmers learn how to take advantage of hash object programming by comparing traditional processing techniques to those that use hash objects. Additionally, users from diverse fields with different requirements can adapt the examples in SAS Hash Object Programming Made Easy to fit their unique situations. This book is part of the SAS Press program.

SAS Programming for Enterprise Guide Users, Second Edition

DOWNLOAD NOW »

Author: Neil Constable

Publisher: SAS Institute

ISBN: 1629597791

Category: Mathematics

Page: 308

View: 4694

New and updated for SAS Enterprise Guide 4.2! 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. This book is part of the SAS Press program.

The Essential Guide to SAS Dates and Times

DOWNLOAD NOW »

Author: Derek P. Morgan

Publisher: SAS Institute

ISBN: 1599941066

Category: Computers

Page: 172

View: 1560

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.

SAS Functions by Example, Second Edition

DOWNLOAD NOW »

Author: Ron Cody, EdD

Publisher: SAS Institute

ISBN: 9781607643647

Category: Mathematics

Page: 472

View: 3516

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.

SAS Programming for Enterprise Guide Users, Second Edition

DOWNLOAD NOW »

Author: Neil Constable

Publisher: SAS Institute

ISBN: 9781607645276

Category: Computers

Page: 308

View: 4893

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.

Mastering the SAS DS2 Procedure

Advanced Data-Wrangling Techniques, Second Edition

DOWNLOAD NOW »

Author: Mark Jordan

Publisher: SAS Institute

ISBN: 1635266068

Category: Computers

Page: 192

View: 3624

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.

Cody's Data Cleaning Techniques Using SAS, Second Edition

DOWNLOAD NOW »

Author: Ron Cody

Publisher: SAS Institute

ISBN: 1629597732

Category: Mathematics

Page: 268

View: 4784

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.

SAS Essentials

Mastering SAS for Data Analytics

DOWNLOAD NOW »

Author: Alan C. Elliott,Wayne A. Woodward

Publisher: John Wiley & Sons

ISBN: 1119042178

Category: Education

Page: 448

View: 9103

A step-by-step introduction to using SAS® statistical software as a foundational approach to data analysis and interpretation Presenting a straightforward introduction from the ground up, SAS® Essentials: Mastering SAS for Data Analytics, Second Edition illustrates SAS using hands-on learning techniques and numerous real-world examples. Keeping different experience levels in mind, the highly-qualified author team has developed the book over 20 years of teaching introductory SAS courses. Divided into two sections, the first part of the book provides an introduction to data manipulation, statistical techniques, and the SAS programming language. The second section is designed to introduce users to statistical analysis using SAS Procedures. Featuring self-contained chapters to enhance the learning process, the Second Edition also includes: Programming approaches for the most up-to-date version of the SAS platform including information on how to use the SAS University Edition Discussions to illustrate the concepts and highlight key fundamental computational skills that are utilized by business, government, and organizations alike New chapters on reporting results in tables and factor analysis Additional information on the DATA step for data management with an emphasis on importing data from other sources, combining data sets, and data cleaning Updated ANOVA and regression examples as well as other data analysis techniques A companion website with the discussed data sets, additional code, and related PowerPoint® slides SAS Essentials: Mastering SAS for Data Analytics, Second Edition is an ideal textbook for upper-undergraduate and graduate-level courses in statistics, data analytics, applied SAS programming, and statistical computer applications as well as an excellent supplement for statistical methodology courses. The book is an appropriate reference for researchers and academicians who require a basic introduction to SAS for statistical analysis and for preparation for the Basic SAS Certification Exam.

Learning SAS by Example

A Programmer's Guide, Second Edition

DOWNLOAD NOW »

Author: Ron Cody

Publisher: SAS Institute

ISBN: 1635266564

Category: Computers

Page: 536

View: 7149

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.

Exercises and Projects for The Little SAS Book, Fifth Edition

DOWNLOAD NOW »

Author: Rebecca A. Ottesen,Lora D. Delwiche,Susan J. Slaughter

Publisher: SAS Institute

ISBN: 1629598054

Category: Mathematics

Page: 148

View: 5803

Challenge and improve your SAS skills through thought-provoking questions, exercises, and projects. Each chapter in Exercises and Projects for The Little SAS Book is matched to a chapter in The Little SAS Book, Fifth Edition. This hands-on workbook is designed to hone your SAS skills whether you are a student or a professional. This book covers DATA step programming, report writing, statistical and graphical procedures, the Output Delivery System, macros, and more; contains a mixture of multiple-choice questions, open-ended discussion topics, and programming exercises with selected answers and hints; and includes comprehensive programming projects that are designed to encourage self-study and to test the skills developed by The Little SAS Book. --

Biostatistics by Example Using SAS Studio

DOWNLOAD NOW »

Author: Ron Cody

Publisher: SAS Institute

ISBN: 1629604933

Category: Computers

Page: 262

View: 1239

Learn how to solve basic statistical problems with Ron Cody's easy-to-follow style using the point-and-click SAS Studio tasks. Aimed specifically at the health sciences, Biostatistics by Example Using SAS Studio, provides an introduction to SAS Studio tasks. The book includes many biological and health-related problem sets and is fully compatible with SAS University Edition. After reading this book you will be able to understand temporary and permanent SAS data sets, and you will learn how to create them from various data sources. You will also be able to use SAS Studio statistics tasks to generate descriptive statistics for continuous and categorical data. The inferential statistics portion of the book covers the following topics: paired and unpaired t tests one-way analysis of variance N-way ANOVA correlation simple and multiple regression logistic regression categorical data analysis power and sample size calculations Besides describing each of these statistical tests, the book also discusses the assumptions that need to be met before running and interpreting these tests. For two-sample tests and N-way tests, nonparametric tests are also described. This book leads you step-by-step through each of the statistical tests with numerous screen shots, and you will see how to read and interpret all of the output generated by these tests. Experience with some basic statistical tests used to analyze medical data or classroom experience in biostatistics or statistics is required. Although the examples are related to the medical and biology fields, researchers in other fields such as psychology or education will find this book helpful. No programming experience is required. Loading data files into SAS University Edition? Click here for more information.

SAS 9.4 SQL Procedure User's Guide

DOWNLOAD NOW »

Author: SAS Institute

Publisher: SAS Institute

ISBN: 1612906532

Category: Computers

Page: 480

View: 8489

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 User's Guide to the Technical Training Schoolhouse Model

DOWNLOAD NOW »

Author: Thomas Manacapilli,Bart Bennett

Publisher: Rand Corporation

ISBN: 0833039970

Category: Business & Economics

Page: 79

View: 6556

This report serves as a front-end user's guide to the RAND schoolhouse model, developed to inform policy decisions regarding technical training pipeline issues within the Air Education and Training Command (AETC). It provides front-end users with a reference for collecting and implementing data and briefly describes the simulation model and its uses.