EPI 697 (ADVANCED TOPICS IN SAS)

• ONE-STOP FOR SAS PAPERS ON VARIOUS TOPICS
  Lex Jansen's Web Site

---

• SEMINAR SERIES, SPRING 2017
  
  
  PAPERS

  Beyond FORMAT Basics
  PROC SQL for DATA Step Die-hards (Williams)
  The Basics of Map Creation with SAS/GRAPH (SUGI 29)
  

  PRESENTATIONS

  Presentation on Formats/Montreal SAS Users Group (MONSUG)
  Presentation on Map Creation with SAS/GRAPH (SUGI 29)
  

  VERSION 9.4 MANUALS IN PDF FORMAT

  SAS/GRAPH 9.4: Mapping Reference
  Examples (SAS Code) from the SAS/GRAPH 9.4 Mapping Reference
  

  SAS CODE

  Beyond Format Basics
  Presentation on Formats/Montreal SAS Users Group (MONSUG)
  Search for Diagnoses
  LIKERT Scale(Identify Patterns)
  PROC SQL Examples (from Williams paper+)
  SAS Dictionary Tables
  Moving Averages (Data Step and PROC SQL)
  How to Add Zero Marginal Totals to Tables in PROC FREQ
  Long-to-Wide ... Rearranging Data with PROC TRANSPOSE, Arrays, IDGROUPs
  Table Lookups Using MERGE, SQL, FORMAT, INDEXES, HASH TABLES, TEMPORAY ARRAYS (Part 1)
  Table Lookups Using MERGE, SQL, FORMAT, INDEXES, HASH TABLES, TEMPORAY ARRAYS (Part 2)
  TRAFIC LIGHTING to Highlight Table Values (includes data set)
  PROC SUMMARY to Create All Possible Combinations of Variable Values
  

  PROBLEMS

  LIKERT Scale(Identify Patterns)
  BOOKS(Find 'Popular Books')

  DATA FOR PROBLEMS

  LIKERT Scale/SAS Data Set (Identify Patterns)
  BOOKS/Raw Data (Find 'Popular Books')
  Download U.S. Population Data 1969-2015
  Standard Populations (Millions) for Age-Adjustment

BOOKS

PROC SQL by Example: Using SQL within SAS
Maps Made Easy Using SAS

---

• ARRAYS
  
  
  PAPERS

  Arrays, a Powerful Time Saver
  Arrays Made Easy: An Introduction to Arrays and Array Processing
  Using SAS Arrays to Manipulate Data
  STOP! WAIT! GO! See What Traffic-Lighting Can Do For You
  Searching for Variable Values with CAT Functions: An Alternative to Arrays and Loops

  SAS CODE

  Using Arrays (inludes data set)
  Traffic Lighting (inludes data set)
  CAT Functions (examples 1 through 9)

---

• USING PROCEDURES TO CREATE DATA SETS
  
  
  PAPERS

  Age-Adjusting a Rate

  SAS CODE

  Age-Adjust (inludes data file and data set)
  Missing Data Report

---

• ADVANCED TOPICS IN FORMATS
  
  
  PAPERS

  Beyond Format Basics
  Presentation on Formats for Montreal SAS Users Group (MONSUG)
  The Power of PROC FORMAT

  SAS CODE

  Beyond Format Basics
  Montreal SAS Users Group (MONSUG)
  The Power of PROC FORMAT
  

---

• FORMAT ALTERNATIVES (RECORD SELECTION, RECORD MATCHING)
  
  
  PAPERS

  The Basics of Using SAS Indexes
  Getting Started with the DATA Step Hash Object
  Getting Started with the DATA Step Hash Iterator
  How Do I Love Hash Tables? Let Me Count The Ways!
  Better Hashing in SAS 9.2
  Hash Crash and Beyond
  HOW to DoW
  The DOW-Loop Unrolled

  SAS CODE

  Format Alternatives
  HOW to DoW

---

• SQL
  
  
  PAPERS

  PROC SQL for Data Step Die-hards
  Proc SQL -- A Primer for SAS Programmers
  Ten Good Reasons to Learn SAS Software's Procedure
  V9.3 SQL Procedures Guide (SAS Manual)
  An SQL Tutorial -- Some Random Tips
  SQL Joins -- The Long and The Short of It
  Dictionary Tables (SAS Help Files)
  Accessing SAS System Information by Using DICTIONARY Tables (SAS Help File)
  Some Utility Applications of the Dictionary Tables in PROC SQL
  Creating MACRO Variables Via PROC SQL
  

  BOOK

  PROC SQL by Example: Using SQL within SAS
  

  SAS CODE

  PROC SQL for Data Step Die-hards
  Using Dictionary Tables
  PROC SQL by Example: Using SQL within SAS
  V9.2 SQL Procedures Guide (SAS Manual)
  

  TUTORIALS

  Interactive Online SQL Training
  Introduction to Structured Query Language
  

  ---

• MACROS
  
  
  PAPERS

  An Introduction to MACRO Variables and MACRO Programs
  Creating MACRO Variables Via PROC SQL
  The Big Introduction from the Smallest Macro (great paper, ZEN of macros)

  BOOK

  Carpenter's Complete Guide to the SAS Macro Language, Second Edition
  SAS 9.2 Macro Language Reference (SAS Manual)
  

  SAS CODE

  An Introduction to MACRO Variables and MACRO Programs
  Creating MACRO Variables Via PROC SQL
  Carpenter's Complete Guide to the SAS Macro Language, Second Edition
  

---

• CHARACTER FUNCTIONS
  
  
  PAPERS

  An Introduction to SAS Character Functions
  

  BOOK

  SAS Functions by Example, Second Edition
  

---

• HANDOUTS SELECT A HANDOUT SEARCHING FOR VARIABLE VALUES WITH CAT FUNCTIONS: AN ALTERNATIVE TO ARRAYS AND LOOPS USING PROCEDURES TO CREATE SAS DATA SETS PDF FILE WITH SAS CODE USED IN USING PROCEDURES TO CREATE SAS DATA SETS BEYOND FORMAT BASICS AN INTRODUCTION TO MACRO VARIABLES AND MACRO PROGRAMS REVISED EXAMPLES 6 THROUGH 12 OF INTRO MACRO PAPER ASSORTED MACRO EXAMPLES CREATING MACRO VARIABLES VIA PROC SQL PROC SQL FOR DATA STEP DIE-HARDS SO YOU'RE STILL NOT USING PROC REPORT. WHY NOT? SO NOW YOU'RE USING PROC REPORT. IS IT PRETTY AND AUTOMATED? SO YOU WANT TO LEARN PROC REPORT AN INTRODUCTION TO SAS/GRAPH SOFTWARE VIA THE GPLOT PROCEDURE AN INTRODUCTION TO CREATING MAPS WITH SAS/GRAPH GETTING STARTED WITH DYNAMIC DATA EXCHANGE


• EXAMPLES/DATA FROM HANDOUTS SELECT EXAMPLES/DATA SEARCHING FOR VARIABLE VALUES WITH CAT FUNCTIONS: AN ALTERNATIVE TO ARRAYS AND LOOPS USING PROCEDURES TO CREATE SAS DATS SETS BEYOND FORMAT BASICS AN INTRODUCTION TO MACRO... CREATING MACRO VARIABLES VIA PROC SQL PROC SQL FOR DATA STEP DIE-HARDS SO YOU'RE STILL NOT USING PROC REPORT. WHY NOT? SO NOW YOU'RE USING PROC REPORT. IS IT PRETTY AND AUTOMATED? AN INTRODUCTION TO SAS/GRAPH SOFTWARE VIA THE GPLOT PROCEDURE AN INTRODUCTION TO CREATING MAPS WITH SAS/GRAPH GETTING STARTED WITH DYNAMIC DATA EXCHANGE DISTANCE TO ALBANY MED (CLASS OF 02/20/2004)


• PAPERS/DOCUMENTATION SELECT A PAPER USING THE OUTPUT DELIVERY SYSTEM (FROM SAS/STAT DOCUMENTATION) INTRODUCTION TO STRUCTURED QUERY LANGUAGE SOME UTILITY APPLICATIONS OF THE DICTIONARY TABLES IN PROC SQL AN INTRODUCTION TO THE SQL PROCEDURE QUALITY CONTROL WITH SAS NUMERIC DATA NUMERIC DATA IN SAS: GUIDELINES FOR STORAGE AND DISPLAY NUMERIC PRECISION 101 (FROM SAS SUPPORT WEB SITE) DEALING WITH NUMERIC REPRESENTATION ERROR IN SAS APPLICATIONS (FROM SAS SUPPORT WEB SITE) THE DATA STEP IN V9: WHAT'S NEW (FROM SAS SUPPORT WEB SITE) SQL JOINS -- THE LONG AND THE SHORT OF IT INSIDE PROC SQL'S QUERY OPTIMIZER PERFORMANCE ENHANCEMENTS TO PROC SQL IN VERSION 7 OF THE SAS SYSTEM UNDOCUMENTED AND HARD-TO-FIND SQL FEATURES SAS PROGAMMING II (BOOK, EXERCISES, DATA, DATA SETS)