SAS For Dummies

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, 2^nd 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.

Introduction 1

Part I: Welcome to SAS! 7

Chapter 1:Touring the Wonderful World of SAS 9

Chapter 2: Your Connection to SAS: Using SAS Enterprise Guide 19

Chapter 3: Six-Minute Abs: Getting Miraculous Results with SAS 43

Part II: Gathering Data and Presenting Information 73

Chapter 4: Accessing Data: Oh, the Choices! 75

Chapter 5: Managing Data: I Can Do That? 95

Chapter 6: Show Me a Report in Less Than a Minute 123

Chapter 7: Graphs: More Value with SAS 143

Part III: Impressing Your Boss with Your SAS Business Intelligence 161

Chapter 8: A Painless Introduction to Analytics 163

Chapter 9: More Analytics to Enlighten and Entertain 177

Chapter 10: Data Mining: Making the Leap from Guesses to Smart Choices 187

Part IV: Enhancing and Sharing Your SAS Masterpieces 199

Chapter 11: Leveraging Work from SAS to Those Less Fortunate 201

Chapter 12: Use OLAP and Impress Your Coworkers 221

Chapter 13: Supercharge Microsoft Office with SAS 237

Chapter 14: Web Reporting Fever: SAS Has That Covered 257

Part V: Getting SAS Ready to Rock and Roll 269

Chapter 15: Setting Up SAS 271

Chapter 16: SAS Programming for the Faint of Heart 283

Chapter 17: The New World Meets the Old: Programmers and SAS Enterprise Guide 301

Part VI: The Part of Tens 315

Chapter 18: Ten SAS Enterprise Guide Productivity Tips 317

Chapter 19: Ten Tips for Administrators 323

Chapter 20: Ten (or More) Web Resources for Extra Information 333

Index 337

Stephen McDaniel is Principal and cofounder of Freakalytics LLC, which provides training and consulting for data presentation, visual data exploration, and dashboard development.

Chris Hemedinger works in SAS R&D on the team that builds SAS Enterprise Guide, a popular user interface for SAS customers.

Learn to:

• Use SAS^®9 statistical and analytical tools
• Get various types of data into the software
• Use Web tools to produce reports
• Work with operational, financial, performance, and sales data

Use SAS^® to meet your data management, analysis, reporting, and forecasting needs

Thousands of businesses use hundreds of SAS products to manage and deliver their data more effectively and create reports that mean something. Are you ready to join them? This book helps you use and understand basic SAS software, including SAS^® Enterprise Guide^®, SAS^® Add-In for Microsoft^® Office, and SAS^® Web Report Studio.

• Swiss army knife — learn how SAS^® Enterprise Guide^® facilitates both access to and protection of corporate data
• They can do it themselves — see how your analysts can create their own reports with SAS tools
• Data can't hide — use infomaps and administered libraries to find data hiding in your PC
• It's mine — make your data mining more effective with SAS^® Enterprise Miner™
• Show me the report — find out how to create reports in plain text, PDF, RTF, HTML, and SAS Report formats
• Intelligent BI — explore the concepts of statistics and analytics as they relate to quality business intelligence
• It's everywhere — learn to use SAS from your desktop, on the Web, in Excel, and even in PowerPoint
• A peek at programming — discover how to tweak SAS to fit your needs perfectly

Open the book and find:

• How SAS^® turns data into useful information
• A dozen types of graphs you can create
• Why the IT department loves SAS^®
• Installation and setup advice
• Where to find real-world SAS^® success stories
• How to create SAS^® content to share with others
• Online SAS^® resources