Combining and Modifying SAS Data Sets
Combining and Modifying SAS Data Sets

Author: Michele M. Burlew

Publisher:

Published: 2019-08-16

Total Pages: 332

ISBN-13: 9781642953077

DOWNLOAD EBOOK

Building on the popularity of the first edition, Michele Burlew has revised this popular examples book to include expanded content and new features of SAS software. Completely updated for SAS 9.2, Combining and Modifying SAS Data Sets: Examples, Second Edition, presents examples that show solutions to common programming tasks that involve combining, modifying, and reshaping data sets. Expanded examples demonstrate how to combine data sets vertically and horizontally; retrieve data from lookup tables; modify and update data sets; combine summary and detail data sets; reshape and transpose observations in a data set; and manipulate data in a data set with utilities and functions. The tools used to combine and modify data sets include the SET, MERGE, MODIFY, and UPDATE statements in the DATA step; joins and set operators in PROC SQL; BY-group processing; indexes; hash objects in the DATA step; the use of PROC FORMAT and hash tables as table lookups; and generation data sets. Unique features of this book include the following: Examples are grouped by task, not by code, so you can easily find a solution to a particular task; alternative solutions are presented in addition to the main examples; most examples that combine and modify data sets include both a DATA step and a PROC SQL solution; many examples include a "Closer Look" section that describes in-depth how the example helps you complete the task; and each example stands on its own so you do not need to read the book from beginning to end. Designed for SAS programmers at all levels, this examples book will help simplify the challenging task of combining and modifying data sets.

Combining and Modifying SAS Data Sets
Combining and Modifying SAS Data Sets

Author: SAS Institute

Publisher: SAS Press

Published: 1995

Total Pages: 0

ISBN-13: 9781555442200

DOWNLOAD EBOOK

Combining and Modifying SAS Data Sets: Examples provides solutions for common tasks involving reshaping or combining SAS data sets. You can save programming hours by using these programs as a model for developing your own. In addition, examples demonstrate basic tasks such as converting a variable's type, working with character strings, and working with SAS time and date values, among others. Data combining and modifying tools used in these examples include DATA step features such as the SET, MERGE, and MODIFY statements; BY-group processing; array processing; and error handling; as well as the SQL procedure. This book is designed for intermediate to advanced SAS programmers who need minimal explanation and who can learn by example. The code is documented in margin notes, with only the most complicated issues explained in more detail. Chapter 1 and some examples direct you to sources of more complete information on the tools and concepts used. Book jacket.

Learning SAS by Example
Learning SAS by Example

Author: Ron Cody

Publisher: SAS Institute

Published: 2018-07-03

Total Pages: 536

ISBN-13: 1635266564

DOWNLOAD EBOOK

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.

The Little SAS Book
The Little SAS Book

Author: Lora D. Delwiche

Publisher: SAS Institute

Published: 2019-10-11

Total Pages: 512

ISBN-13: 1642953431

DOWNLOAD EBOOK

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 that 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. Nearly every section has been revised to ensure that the sixth edition is fully up-to-date. This edition is also interface-independent, written for all SAS programmers whether they use SAS Studio, SAS Enterprise Guide, or the SAS windowing environment. New sections have been added covering PROC SQL, iterative DO loops, DO WHILE and DO UNTIL statements, %DO statements, using variable names with special characters, the ODS EXCEL destination, and the XLSX LIBNAME engine. This title belongs on every SAS programmer's bookshelf. It's a resource not just to get you started, but one you will return to as you continue to improve your programming skills. Learn more about the updates to The Little SAS Book, Sixth Edition here. Reviews for The Little SAS Book, Sixth Edition can be read here.

Handbook of SAS® DATA Step Programming
Handbook of SAS® DATA Step Programming

Author: Arthur Li

Publisher: CRC Press

Published: 2013-04-10

Total Pages: 278

ISBN-13: 1466552387

DOWNLOAD EBOOK

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.

SAS Certified Specialist Prep Guide
SAS Certified Specialist Prep Guide

Author: SAS Institute

Publisher: SAS Institute

Published: 2019-02-11

Total Pages: 434

ISBN-13: 1642951765

DOWNLOAD EBOOK

The SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4 prepares you to take the new SAS 9.4 Base Programming -- Performance-Based Exam. This is the official guide by the SAS Global Certification Program. This prep guide is for both new and experienced SAS users, and it covers all the objectives that are tested on the exam. New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers for the chapter quizzes and solutions for the sample scenarios in the workbook are included. You will also find links to exam objectives, practice exams, and other resources such as the Base SAS® glossary and a list of practice data sets. Major topics include importing data, creating and modifying SAS data sets, and identifying and correcting both data syntax and programming logic errors. All exam topics are covered in these chapters: Setting Up Practice Data Basic Concepts Accessing Your Data Creating SAS Data Sets Identifying and Correcting SAS Language Errors Creating Reports Understanding DATA Step Processing BY-Group Processing Creating and Managing Variables Combining SAS Data Sets Processing Data with DO Loops SAS Formats and Informats SAS Date, Time, and Datetime Values Using Functions to Manipulate Data Producing Descriptive Statistics Creating Output Practice Programming Scenarios (Workbook)

Cody's Data Cleaning Techniques Using SAS, Third Edition
Cody's Data Cleaning Techniques Using SAS, Third Edition

Author: Ron Cody

Publisher: SAS Institute

Published: 2017-03-15

Total Pages: 234

ISBN-13: 1635260698

DOWNLOAD EBOOK

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 which will make your job of data cleaning easier, faster, and more efficient. --

SAS Language Reference
SAS Language Reference

Author: SAS Institute

Publisher: SAS Press

Published: 1999

Total Pages: 0

ISBN-13: 9781580254410

DOWNLOAD EBOOK

This book comprehensively documents essential concepts for SAS features, the DATA step, and SAS files. Topics include basic SAS concepts such as SAS processing, SAS names, missing values, expressions, time and date values, WHERE-expression processing, SAS output, and error processing and debugging; SAS DATA step concepts such as DATA step processing, reading rawdata, combining and modifying SAS data sets, BY-group processing, array processing, and creating and using stored compiled SAS programs; and SAS file concepts such as SAS data libraries, SAS data sets (SAS data files and SAS data views), indexes, file protection, SAS I/O engines, SAS file management, and external files.