SAS BEGINNER’S GUIDE
ABOUT THIS BOOK FOOLISH ASSUMPTIONS WHAT NOT TO READ CONVENTIONS USED IN THIS BOOK ICONS USED IN THIS BOOK HOW THIS BOOK IS ORGANIZED PART I: WELCOME TO SAS! PART II: GATHERING DATA AND PRESENTING INFORMATION PART III: IMPRESSING YOUR BOSS WITH YOUR SAS BUSINESS INTELLIGENCE PART IV: ENHANCING AND SHARING YOUR SAS MASTERPIECES PART V: GETTING SAS READY TO ROCK AND ROLL PART VI: THE PART OF TENS WHERE TO GO FROM HERE SAS — ISN’T THAT JUST FOR GURUS? DATA, DATA EVERYWHERE — BUT NOT WHERE I NEED IT! DATA SUMMARIES AND REPORTING THE SECRET SAUCE: ANALYTICS TO OPTIMIZE THE PRESENT AND PREDICT THE FUTURE SHARING THE SAS WEALTH WHAT THE IT DEPARTMENT NEEDS TO KNOW CHECKING OUT REAL-WORLD SUCCESS STORIES USING SAS ENTERPRISE GUIDE, THE SWISS ARMY KNIFE OF SAS USING SAS ENTERPRISE GUIDE FOR THE FIRST TIME CHANGING WHAT YOU SEE ON-SCREEN ACCESSING AND MANAGING DATA OPENING SAS DATA SETS FILTERING SAS DATA VISUALIZING SUCCESS WITH CHARTS CREATING REPORTS FOR EVEN THE CRANKIEST MANAGER CREATING A SUMMARY TABLE REPORT ENRICHING A SUMMARY TABLE REPORT WITH GRAPHS WHERE IS MY DATA SET COMING FROM AND WHERE IS IT GOING? QUERYING YOUR WAY TO SUCCESS WHAT’S ALL THIS TALK OF JOINING? JOINING DATA FROM MULTIPLE TABLES CREATING COMPUTED COLUMNS FORMATTING YOUR COMPUTED COLUMNS SUMMARIZING THE DATA SUMMARIZING SPECIFIC NUMERIC VARIABLES BUILDING A FORECAST MICROSOFT EXCEL, MICROSOFT ACCESS, AND TEXT FILES: ACCESSING THE DATA HIDDEN ON YOUR PC IMPORTING AN EXCEL WORKBOOK OLE! ACCESSING YOUR DATA WITHOLE DB AND ODBC IMPORTING AN ACCESS DATABASE TABLE WITH ODBC IMPORTING AN ACCESS DATABASE TABLE WITH OLE DB MORE WAYS TO ACCESS DATA FROM YOUR PC SERVER-BASED DATA: CAN YOU SUPER-SIZE THAT? MAKE LIKE A LIBRARY AND BOOK TAKING A QUICK LOOK AT WHAT YOU CAN DO WITH DATA QUERIES: BRINGING YOUR DATA TOGETHER AND MAKING IT SING (OR AT LEAST HUM) JOINING TABLE DATA FILTERING TABLE DATA SELECTING SPECIFIC COLUMNS OF DATA CREATING A COMPUTED COLUMN RECODING A COLUMN SORTING DATA PARAMETERIZING THE QUERY FILTER A PARAMETERIZED QUERY EXAMPLE EDITING, SORTING, RANKING, TRANSPOSING, AND OTHER DATA CONTORTIONS EDITING DATA TABLE VALUES APPENDING TABLES CREATING A FORMAT TRANSPOSING DATA SPLITTING COLUMNS STACKING COLUMNS SELECTING A RANDOM SAMPLE OF DATA RANKING VARIABLES STANDARDIZING DATA SUMMARIZING DATA SET ATTRIBUTES COMPARING DATA DELETING DATA SETS AND FORMATS TRYING OUT THE DATA MANAGEMENT TASKS REDUCING THE VOLUME OF DATA TRANSPOSING THE DATA CREATING A SUMMARY REPORT DISCOVERING YOUR REPORTING OPTIONS PLAIN TEXT REPORTS ADOBE ACROBAT (PDF) REPORTS RICH TEXT FORMAT (RTF) REPORTS HTML FORMAT REPORTS SAS REPORT (SRX) FORMAT REPORTS DATA LISTINGS AND SUMMARIES FOR THE LISTLESS THE LIST DATA TASK CREATING A SALES REPORT FINE-TUNING YOUR SALES REPORT FORMATTING THE CHARACTERIZE DATA TASK: WHAT DID THAT GUY IN ACCOUNTING JUST GIVE ME? THE SUMMARY STATISTICS TASK: GET TO THE POINT! THE SUMMARY TABLES (CROSS-TABS) TASK: EASIER THAN CROSSWORDS! CREATING A SUMMARY TABLE ENABLING FORMATTING IN WIZARDS GRAPHING BASICS GRAPHS FOR EVERY OCCASION BAR CHARTS PIE CHARTS LINE PLOTS SCATTER PLOTS AREA PLOTS BUBBLE PLOTS BOX PLOTS DONUT CHARTS CONTOUR PLOTS MAP GRAPHS CREATING GRAPHS WITH SAS A BOX PLOT EXAMPLE: FINDING THE EXTREME PRODUCTS A LINE PLOT EXAMPLE: TRACKING THE REGIONS PREPPING YOUR DATA CREATING YOUR LINE PLOT GRAPH ANALYTIC CONCEPTS USEFUL FOR EVERYONE IT’S VARIABLE P-VALUES HOW CONFIDENT ARE YOU? WHAT DID YOUR MOTHER SAY ABOUT MAKING ASSUMPTIONS? DISTRIBUTION ANALYSIS — DESCRIBING YOUR DATA ANALYZING COUNTS AND FREQUENCIES TRANSFORMING YOUR DATA FOR FURTHER USE BASIC DATA ANALYSIS VIA CORRELATION TECHNIQUES ANOVA AND REGRESSION: NO PHD REQUIRED! STAYING ALIVE WITH SURVIVAL ANALYSIS QUALITY CONTROL: YOU WANT SOMETHING THAT WORKS? HISTOGRAMS Q-Q PLOTS AND PROBABILITY PLOTS CONTROL CHARTS PARETO CHARTS MULTIVARIATE ANALYSIS: UNDERSTANDING COMPLEX RELATIONSHIPS PRINCIPAL COMPONENT ANALYSIS CLUSTER ANALYSIS AND DISCRIMINANT ANALYSIS FORECASTING: USING THE CRYSTAL BALL DATA MINING: PRECIOUS JEWELS IN YOUR DATA OUTPUT DELIVERY WITH NO EXTRA POSTAGE REQUIRED GETTING COZY WITH ODS CREATING A REPORT WITH STYLE CHECKING OUT GRAPH STYLES: A CHART-TOPPING PERFORMANCE POWER OF THE PALETTE: CREATING YOUR OWN STYLES THE GEOGRAPHY OF STYLES SWEETENING YOUR OUTPUT WITH A CUSTOM STYLE MIXING STYLE AND SUBSTANCE: CONVEYING MEANING WITH STYLE PLAIN TEXT IS NOT DEAD YET PULLING OUT RESULTS WITHOUT PULLING TEETH EXPORTING RESULTS, DUTY-FREE EXPORT AS A STEP: BAKING IT INTO THE RECIPE GETTING CONTENT TO THE CHANNEL SURFERS USING ONLY THE GOOD BITS: ASSEMBLING REPORTS IN A SNAP SELECTING YOUR MIX INGREDIENTS HTML DOCUMENT BUILDER: STACKING IT UP FOR THE WEB CREATING REPORTS SUITABLE FOR FRAMING PRACTICING FENG SHUI IN REPORT DESIGN HARMONY IS JUST A FEW CLICKS AWAY CANNING YOUR WORK FOR OTHERS TO USE IN STORED PROCESSES ALMOST LIKE CLONING YOURSELF DISTILLING THE COMPLEX DOWN TO THE SIMPLE WHO INVITED ALL THE CUBES? OLAP FEATURES OLAP TABLE INTERACTION DRILLING AND EXPANDING YOUR MIND FILTERING OUT THE WEAK AND MEMBER ISOLATION TABLES GIVE ME HEADACHES: WHAT ABOUT GRAPHS AND MAPS? IT’S ALL RELATIVE: UNDERSTANDING THE PERCENTAGES A SLICE OF DATA FOR FURTHER ANALYSIS MORE OLAP FEATURES BOOKMARKING: WHERE WAS I? USING CALCULATED MEASURES DRILLING DOWN: JUST THE FACTS, PLEASE CONDITIONAL FORMATTING: ISN’T THAT SPECIAL? ADDING DETAILS ABOUT YOUR VALUES SPEAKING MDX WITH THE OLAP CUBE THE POWER OF SAS FROM THE COZY WORLD OF OFFICE SAS ADD-IN FOR MICROSOFT OFFICE OPTIONS KNOWING WHICH OFFICE APPLICATIONS ARE SUPPORTED USING THE ADD-IN TO GET THE MOST OUT OF OFFICE INTEGRATION ACCESSING AND MANAGING DATA OF ANY SIZE FROM ALMOST ANYWHERE OPENING DATA WITH THE ADD-IN USING THE ADD-IN TO MOVE YOUR EXCEL DATA TO SAS AD HOC ANALYSIS: AWESOME! TURN, STEP, PIVOT (TABLE)! USING SAS TASKS FROM THE ADD-IN STORED PROCESSES: LEAVING SPREADSHEET HELL CHECKING OUT AN EXAMPLE OF HOW NOT TO USE DATA ACCESSING STORED PROCESSES VIA THE ADD-IN REFRESHING RESULTS FROM THE ADD-IN SHARING YOUR WORK WITH OTHERS SELF-SERVICE REPORTING FOR EVERYONE GOING BEYOND BASIC REPORTING MORE DETAILS ON SAS WEB REPORT STUDIO CHECKING OUT SOME COOL REPORT EXAMPLES SECURING REPORTS PRINTING SMART EXPORTING DATA TO MICROSOFT EXCEL SCHEDULING REPORTS HOW COMPLICATED? IT DEPENDS THE SWEETEST SETUP: LOCAL-LOCAL DISTRIBUTING SAS TO THE MASSES DROWNING IN TIERS: TALKING ACROSS BOUNDARIES METADATA: THE KEYS TO THE KINGDOM GOOD NEWS TRAVELS FAST — HOW ABOUT YOUR DATA? CRASH COURSE IN DATA PLUMBING PASSING NIAGARA FALLS THROUGH A GARDEN HOSE SAS/ACCESS: THE PLUMBER’S HELPER EXAMPLE: PROJECT MEETS DATA, JUST IN TIME DATA WAREHOUSING: DO I REALLY NEED TO THINK ABOUT THIS? FUNDAMENTAL PRINCIPLES OF DATA WAREHOUSING THE VALUE OF WELL-MANAGED DATA MARTS GETTING ORGANIZED WITH PROJECTS CONNECTING THE DOTS WITH LINKS AVOID ENTROPY WITH THE ORDERED LIST THE PROJECT LOG: YOUR WORK ON RECORD LETTING SAS TASKS DO THE HEAVY LIFTING BEING FLEXIBLE WITH PROJECT PARAMETERS OFF-LIMITS: STUFF THAT WON’T WORK X STATEMENTS AND SYSTASK (TSK TSK) DDE IS DOA NOWHERE TO SHOW: SAS/AF AND %WINDOW ENDING CONTROL WITH ENDSAS THE “KEYS” TO SUCCESS DON’T LIMIT YOURSELF: USE MORE THAN ONE SESSION SEE WHAT’S INSTALLED ON YOUR SERVER THE SWITCHEROO: CHANGING THE INPUT DATA FOR A TASK WATCH THE LOG GROW COPY DATA EXPAND YOUR HORIZONS WITH CUSTOM TASKS SUBMIT A SELECTION DON’T WAIT FOR DATA TO OPEN NEED NOT BE PRESENT TO WIN: SCHEDULE YOUR PROJECT DETERMINING WHEN SASUSER ISN’T USABLE MANAGING LOGINS FROM SAS ENTERPRISE GUIDE EXPLORER DISARMING SAS ENTERPRISE GUIDE EXPLORER USING METALIB TO SYNCHRONIZE METADATA WITH REALITY GETTING BETTER PERFORMANCE FROM INFORMATION MAPS MAKING YOUR DATABASE WORK FOR YOU WITH IMPLICIT PASS-THROUGH CATCHING AND KILLING A RUNAWAY SAS SESSION TELLING ONE SAS EXE FROM ANOTHER PEERING UNDER THE COVERS WITH PROCESS LOGS NEED SOME SUPPORT? WHAT ELSE DOES SAS OFFER AND HOW ARE OTHERS SUCCEEDING WITH SAS? HELP ME OUT WITH MORE INFO ON MAKING EFFECTIVE CHARTS AND GRAPHS WHERE CAN I FIND OUT MORE ABOUT BUSINESS INTELLIGENCE? WHERE CAN I DISCOVER MORE ABOUT STATISTICS AND ANALYTICS? WHAT ABOUT MORE INFORMATION THAT JUST DID NOT FIT IN THIS BOOK?