The Essential Guide to SAS Dates and Times


Book Description

Why does SAS use January 1, 1960 as its arbitrary reference date? How do you convert a value such as 27 January 2003 into a SAS date? How do you put a date into a filename, or label an Excel worksheet with the date? You'll find the answers to these questions and much more in Derek Morgan's Essential Guide to SAS Dates and Times, Second Edition, which makes it easy to understand how to use and manipulate dates, times, and datetimes in SAS. Updated for SAS 9.4, with additional functions, formats, and capabilities, the Second Edition has a new chapter dedicated to the ISO 8601 standard and the formats and functions that are new to SAS, including how SAS works with Universal Coordinated Time (UTC). Novice users will appreciate the new "Troubleshooting" appendix, which discusses questions common to newer SAS users in a conversational way and provides clear examples of simple solutions to these questions. Both novice and intermediate users will find the clear, task-based examples on how to accomplish date-related tasks and the detailed explanations of standard formats and functions invaluable. Users working with intervals will appreciate the expanded discussion of the topic, which details the new custom interval capability, among other enhancements to intervals. Users working with international dates and times will benefit from the detailed discussion of the NLS facility as it relates to dates and times. Included are bonus "Quick Reference Guides" that list both the standard date and time formats and the NLS date and time formats with examples. These guides illustrate how each format displays the same date, time, or datetime, so you can find the format you want to use at a glance. The Essential Guide to SAS Dates and Times, Second Edition is the most complete and up-to-date collection of examples on how to write complex programs involving dates, times, or datetime values. This book is part of the SAS Press Program.




Learning SAS by Example


Book Description

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 Enterprise Guide Book


Book Description

Learning to use SAS Enterprise Guide has never been easier! Whether you are using SAS Enterprise Guide for the first time, or are looking to expand your skills, this is the book for you! With The Little SAS Enterprise Guide Book, award-winning authors Susan Slaughter and Lora Delwiche help you quickly become productive in the SAS Enterprise Guide point-and-click environment. A series of carefully designed tutorials help you master the basics of the tasks you'll want to do most frequently. The reference section of the book expands on the tutorial topics, covering specific features in more depth. This edition has been completely rewritten, and updated with new features in SAS Enterprise Guide.




Practical and Efficient SAS Programming


Book Description

Learn to write SAS programs quickly and efficiently. Programming in SAS is flexible, but it can also be overwhelming. Many novice and experienced programmers learn how to write programs that use the DATA step and macros, but they often don’t realize that a simpler or better way can achieve the same results. In a user-friendly tutorial style, Practical and Efficient SAS® Programming: The Insider's Guide provides general SAS programming tips that use the tools available in Base SAS, including the DATA step, the SAS macro facility, and SQL. Drawing from the author’s 30 years of SAS programming experience, this book offers self-contained sections that describe each tip or trick and present numerous examples. It therefore serves as both an easy reference for a specific question, and a useful cover-to-cover read. As a bonus, the utility programs included in the appendixes will help you simplify your programs, as well as help you develop a sleek and efficient coding style. With this book, you will learn how to do the following: use the DATA step, the SAS macro facility, SQL, and other Base SAS tools more efficiently choose the best tool for a task use lookup tables simulate recursion with macros read metadata with the DATA step create your own programming style in order to write programs that are easily maintained Using this book, SAS programmers of all levels will discover new techniques to help them write programs quickly and efficiently.




The Little SAS Book


Book Description

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.




SAS Programming for Enterprise Guide Users, Second Edition


Book Description

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.




Practical Business Analytics Using SAS


Book Description

Practical Business Analytics Using SAS: A Hands-on Guide shows SAS users and businesspeople how to analyze data effectively in real-life business scenarios. The book begins with an introduction to analytics, analytical tools, and SAS programming. The authors—both SAS, statistics, analytics, and big data experts—first show how SAS is used in business, and then how to get started programming in SAS by importing data and learning how to manipulate it. Besides illustrating SAS basic functions, you will see how each function can be used to get the information you need to improve business performance. Each chapter offers hands-on exercises drawn from real business situations. The book then provides an overview of statistics, as well as instruction on exploring data, preparing it for analysis, and testing hypotheses. You will learn how to use SAS to perform analytics and model using both basic and advanced techniques like multiple regression, logistic regression, and time series analysis, among other topics. The book concludes with a chapter on analyzing big data. Illustrations from banking and other industries make the principles and methods come to life. Readers will find just enough theory to understand the practical examples and case studies, which cover all industries. Written for a corporate IT and programming audience that wants to upgrade skills or enter the analytics field, this book includes: More than 200 examples and exercises, including code and datasets for practice. Relevant examples for all industries. Case studies that show how to use SAS analytics to identify opportunities, solve complicated problems, and chart a course. Practical Business Analytics Using SAS: A Hands-on Guide gives you the tools you need to gain insight into the data at your fingertips, predict business conditions for better planning, and make excellent decisions. Whether you are in retail, finance, healthcare, manufacturing, government, or any other industry, this book will help your organization increase revenue, drive down costs, improve marketing, and satisfy customers better than ever before.




SAS For Dummies


Book Description

The fun and easy way to learn to use this leading business intelligence tool Written by an author team who is directly involved with SAS, this easy-to-follow guide is fully updated for the latest release of SAS and covers just what you need to put this popular software to work in your business. SAS allows any business or enterprise to improve data delivery, analysis, reporting, movement across a company, data mining, forecasting, statistical analysis, and more. SAS For Dummies, 2nd Edition gives you the necessary background on what SAS can do for you and explains how to use the Enterprise Guide. SAS provides statistical and data analysis tools to help you deal with all kinds of data: operational, financial, performance, and more Places special emphasis on Enterprise Guide and other analytical tools, covering all commonly used features Covers all commonly used features and shows you the practical applications you can put to work in your business Explores how to get various types of data into the software and how to work with databases Covers producing reports and Web reporting tools, analytics, macros, and working with your data In the easy-to-follow, no-nonsense For Dummies format, SAS For Dummies gives you the knowledge and the confidence to get SAS working for your organization. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




Data Analysis Using SAS Enterprise Guide


Book Description

This book presents the basic procedures for utilizing SAS Enterprise Guide to analyze statistical data. SAS Enterprise Guide is a graphical user interface (point and click) to the main SAS application. Each chapter contains a brief conceptual overview and then guides the reader through concrete step-by-step examples to complete the analyses. The eleven sections of the book cover a wide range of statistical procedures including descriptive statistics, correlation and simple regression, t tests, one-way chi square, data transformations, multiple regression, analysis of variance, analysis of covariance, multivariate analysis of variance, factor analysis, and canonical correlation analysis. Designed to be used either as a stand-alone resource or as an accompaniment to a statistics course, the book offers a smooth path to statistical analysis with SAS Enterprise Guide for advanced undergraduate and beginning graduate students, as well as professionals in psychology, education, business, health, social work, sociology, and many other fields.




SAS Statistics by Example


Book Description

In SAS Statistics by Example, Ron Cody offers up a cookbook approach for doing statistics with SAS. Structured specifically around the most commonly used statistical tasks or techniques--for example, comparing two means, ANOVA, and regression--this book provides an easy-to-follow, how-to approach to statistical analysis not found in other books. For each statistical task, Cody includes heavily annotated examples using ODS Statistical Graphics procedures such as SGPLOT, SGSCATTER, and SGPANEL that show how SAS can produce the required statistics. Also, you will learn how to test the assumptions for all relevant statistical tests. Major topics featured include descriptive statistics, one- and two-sample tests, ANOVA, correlation, linear and multiple regression, analysis of categorical data, logistic regression, nonparametric techniques, and power and sample size. This is not a book that teaches statistics. Rather, SAS Statistics by Example is perfect for intermediate to advanced statistical programmers who know their statistics and want to use SAS to do their analyses. This book is part of the SAS Press program.