SAS for Dummies (ISBN - 0470539682)

388 Pages·2021·13.04 MB·English

Stephen McDaniel
Chris Hemedinger

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

SAS

®

2nd Edition

Making Everything Easier!™

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

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.

$29.99 US / $35.99 CN / £21.99 UK

ISBN 978-0-470-53968-2

Computers/Mathematical &
Statistical Software

Go to Dummies.com®

for videos, step-by-step examples,
how-to articles, or to shop!

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

SAS

®

McDaniel
Hemedinger

spine=.7680”

2nd Edition

2nd Edition

Start with FREE Cheat Sheets

Cheat Sheets include

• Checklists

• Charts

• Common Instructions

• And Other Good Stuff!

Get Smart at Dummies.com
Dummies.com makes your life easier with 1,000s
of answers on everything from removing wallpaper
to using the latest version of Windows.

Check out our

• Videos

• Illustrated Articles

• Step-by-Step Instructions

Plus, each month you can win valuable prizes by entering
our Dummies.com sweepstakes. *

Want a weekly dose of Dummies? Sign up for Newsletters on

• Digital Photography

• Microsoft Windows & Office

• Personal Finance & Investing

• Health & Wellness

• Computing, iPods & Cell Phones

• eBay

• Internet

• Food, Home & Garden

Find out “HOW” at Dummies.com

*Sweepstakes not currently available in all countries; visit Dummies.com for official rules.

Get More and Do More at Dummies.com®

To access the Cheat Sheet created specifically for this book, go to
www.dummies.com/cheatsheet/sas

spine=.7680”

SAS

®

FOR
DUMmIES

‰

2ND EDITION

01_539682-ffirs.indd i
01_539682-ffirs.indd i
3/2/10 10:49 PM
3/2/10 10:49 PM

01_539682-ffirs.indd ii
01_539682-ffirs.indd ii
3/2/10 10:49 PM
3/2/10 10:49 PM

by Stephen McDaniel and Chris Hemedinger

SAS

®

FOR
DUMmIES

‰

2ND EDITION

01_539682-ffirs.indd iii
01_539682-ffirs.indd iii
3/2/10 10:49 PM
3/2/10 10:49 PM

SAS® For Dummies®, 2nd Edition
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774

www.wiley.com

Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-
ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the
Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone].
Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley
& Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://
www.wiley.com/go/permissions.

Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the
Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything
Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/
or its affi liates in the United States and other countries, and may not be used without written permission.
SAS is a registered trademark of SAS Institute, Inc. All other trademarks are the property of their respec-
tive owners. Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTA-
TIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS
WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES
OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR
PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR
EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED
IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE
IS REQUIRED, THE SERVICES OF A COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE
PUBLISHER NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN
ORGANIZATION OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE
OF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFOR-
MATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER,
READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR
DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services, please contact our Customer Care
Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

For technical support, please visit www.wiley.com/techsupport.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may
not be available in electronic books.

Library of Congress Control Number: 2010922564

ISBN: 978-0-470-53968-2

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

01_539682-ffirs.indd iv
01_539682-ffirs.indd iv
3/2/10 10:49 PM
3/2/10 10:49 PM

About the Authors

Stephen McDaniel has 20 years of experience as a teacher, a consultant, a
leader, an innovator, and an author in the fi elds of visual analytics, business
intelligence, data warehousing, and data mining. Stephen is the author of
Rapid Graphs with Tableau Software and is the cofounder of Freakalytics®, LLC.
Freakalytics offers public training, on-site training, and expert consulting that
delivers “Rapid Analytics to Explore, Understand, Communicate & Act.”

Previously, Stephen was the senior manager in charge of the SAS Enterprise
Guide development team and the SAS Add-In for Microsoft Offi ce develop-
ment team at SAS. Stephen has been a SAS user for more than 20 years and
has experience with more than 50 organizations as a statistician, statistical
programmer, product manager, and manager of data warehousing and busi-
ness intelligence. You can reach him at www.Freakalytics.com.

Chris Hemedinger is a senior software manager in the Research and
Development division of SAS. Chris began his career at SAS in 1993 as
a technical writer, creating such hits as SAS Companion for the OS/2
Environment (remember OS/2?) and SAS Companion for the Microsoft Windows
Environment. In 1997, he became involved in a prototype project to make SAS
easier to use for nonprogrammers, and that project evolved into the hugely
popular SAS Enterprise Guide, a product that Chris has worked with ever
since. Chris can be found performing entertaining SAS tricks at blogs.sas.
com/sasdummy.

01_539682-ffirs.indd v
01_539682-ffirs.indd v
3/2/10 10:49 PM
3/2/10 10:49 PM

01_539682-ffirs.indd vi
01_539682-ffirs.indd vi
3/2/10 10:49 PM
3/2/10 10:49 PM

Dedication

I want to thank my wonderful wife and business partner, Eileen, for her
patience, support, insights, and encouragement throughout the writing
process!—Stephen McDaniel

For my beautiful (and patient) wife, Gail, and our inquisitive three daughters:
Maggie, Evelyn, and Gwen. Listen up, girls: Despite what you hear from me,
it’s usually not polite to call somebody a “dummy.”—Chris Hemedinger

01_539682-ffirs.indd vii
01_539682-ffirs.indd vii
3/2/10 10:49 PM
3/2/10 10:49 PM

01_539682-ffirs.indd viii
01_539682-ffirs.indd viii
3/2/10 10:49 PM
3/2/10 10:49 PM