Updated May 7, 2013

### EPI 514 (COMPUTER APPLICATIONS IN EPIDEMIOLOGY a/k/a INTRODUCTION TO SAS)

• SAS WORKSHOP (ORIENTATION EXERCISES - HOW TO USE SAS)

• ON THE SAS WEB SITE
SAS RESOURCES FOR STUDENTS
SAS STUDENT NETWORK WEB SITE

• NOTES
1/INTRODUCTION (1-18)
2/PROGRAMS, DATA SETS, RULES (19-25)
4/SELECTING AND RESTRICTING OBSERVATIONS (51-65)
5/SELECTING AND RESTRICTING VARIABLES (66-70)
6/PROCEDURES (71-102)
NOTE: there are NO pages 103-124 as of yet
7/FORMATS (125-140)
8+9/DATES+FUNCTIONS (OLD NOTES)
10+11/REARRANGE+COMBINE (OLD NOTES)
APPENDIX A-SAS OPERATORS
APPENDIX B-DEFAULT SORTING ORDER OF CHARACTERS

• EXTRA NOTES
SLIDES WITH RULES FOR CREATING AND USING FORMATS
EXTRA NOTES + SAS CODE ON FIRST. AND LAST. VARIABLES
EXTRA NOTES ON ARRAYS
PRACTICE SAS CODE ON NUMERIC FUCTIONS FROM CODY "SAS FUNCTIONS BY EXAMPLE (CHAPTER 7)"
EXTRA NOTES + SAS CODE ON PROC TRANSPOSE + TRANSPOSE WITH DATA FROM CODY "LEARNING SAS BY EXAMPLES (CHAPTER 23)"

• EXAMPLES FROM NEW NOTES

• EXTRA EXAMPLES
EXTRA PRACTICE FOR QUIZ #1
READING RAW DATA (FORMATTED, COLUMN, LIST INPUT)
MODIFIED EXAMPLE 3.14 FROM NOTES
MODIFIED EXAMPLE 3.15 FROM NOTES
FIRSTOBS AND OBS EXAMPLES (NOT IN NOTES)
SAS CODE FOR ASSSIGNMENT 2
INPUT WITH @ AND @@
IF, WHERE, OUTPUT, DELETE, RETURN

• EXAMPLES FROM OLD NOTES

• ASSIGNMENTS

• DATA FILES FOR ASSIGNMENTS AND EXAMPLES IN NOTES (ALL FILES ARE ZIPPED - USE WINZIP TO 'UNZIP')

• PAPERS AND BOOK EXCERPTS
DATA STEP ESSENTIALS
MISSOVER, TRUNCOVER, AND PAD, OH MY!!
CODY'S DATA CLEANING TECHNIQUES USING SAS SOFTWARE (CHAPTER 1)
DATA CLEANING 101
ANYONE CAN LEARN PROC TABULATE
FREQ-OUT: AN APPLIED PRESENTATION OF THE OPTIONS/OUTPUT OF PROC FREQ
TS-486 QUICK REFERENCE: FUNCTIONS, INFORMATS, FORMATS
READING EXTERNAL DATA FILES USING SAS: EXAMPLES HANDBOOK (CHAPTER 1)
DEBUGGING 101
DON'T BE A SAS DINOSAUR: MODERNIZE YOUR SAS PROGRAMS (COMPLETE BOOK)

• LINKS TO SAS-RELATED WEB SITES
SAS Institute
SAS Programmer's Bookshelf
SAS System Viewer (look at contents of SAS data sets)
Step-by-Step Programming with Base SAS Software (free introductory book)
SAS Documentation --- Links to Documentation by Product and Version
BASE SAS Documentation (on-line in PDF format)
SAS/STAT Documentation (on-line in PDF format)
SAS/GRAPH Documentation (on-line in PDF format)
SAS V9.1.3 Documentation (on-line in PDF format)
SAS V9.1.3 Documentation (on-line in HTML format)
What's New in SAS
SAS Press and SAS Documentation Example Code and Data
SAS Online Resources for Statistics Education
SAS Institute--1000+ Examples of SAS Code for a Variety of Tasks
SAS Institute Publishing (Buy Books, Sample SAS Code)
Northeast SAS Users Group (with a link to papers from proceedings)
JMP Software for Teachers and Students
Mayo Clinic-Biostatistics, SAS Macros
SAS Employee Papers from SUGI + SAS Global Forum (on SAS web site)
Lex Jansen's Web Site (SUGI, NESUG, PharmaSUG Papers)
Base SAS Tip Sheets
Koen Vyverman's Papers on DDE, DOW, Hashing
Nate Derby's SAS Macros
Statistics Tutorials Using SAS Software

• LINKS TO SAS LEARNING SITES
Stat 597C SAS & Data Management at Penn State
STAT 481-Intermediate SAS at Penn State
UCLA SAS Training/Consulting/Resouces
UNC Population Center Topics in SAS Programming

• LINKS TO STATISTICS WEB SITES
S-PLUS Student Version (FREE)
STATSOFT Electronic Textbook
HyperStat Online Textbook
SurfStat Australia
Introduction to the Practice of Statistics (used at UNC School of Public Health)
Introductory Biostatistics
Introductory Biostatistics for the Health Sciences
Biostatistical Methods in Epidemiology
Common Statistical Errors and How to Avoid Them
Categorical Data Analysis

• BOOK RECOMMENDATIONS
LEARN SAS
"Learning SAS by Example: A Programmer's Guide" --- Ron Cody (BEST !!!)
"The Little SAS Book (4th edition)" --- Lora D. Delwiche and Susan J. Slaughter
"The Little SAS Book for Enterprise Guide 4.2" --- Lora D. Delwiche and Susan J. Slaughter (point-and-click approach to SAS)
"The SAS Workbook" --- Ron Cody
"SAS Programming: The One-Day Course" --- Neil H. Spencer (really NOT possible, but interesting !!!)
USING SAS
"SAS Functions by Example" --- Ron Cody
"Cody's Data Cleaning Techniques Using SAS Software (2nd edition) --- Ron Cody
"Professional SAS Programming Logic" --- Rick Aster
"Step-by-Step Programming with Base SAS Software" --- SAS
"Reading External Data Files Using SAS: Examples Handbook" --- Michele M. Burlew
"Output Delivery System: The Basics" --- Lauren Haworth
"PROC TABULATE by Example" --- Lauren Haworth
"Maps Made Easy Using SAS" --- Mike Zdeb
"Carpenter's Complete Guide to the SAS Macro Language (2nd edition)" --- Art Carpenter
HEALTH-RELATED
"Health Care Data and SAS" --- Marge Scerbo, Craig Dickstein, and Alan Wilson
"Common Statistical Methods for Clinical Research with SAS Examples (2nd edition)" --- Glenn Walker
STATISTICS
"Applied Statistics and the SAS Programming Language (5th edition)" --- Ron Cody and Jeff Smith
"SAS System for Elementary Statistical Analysis (2nd edition)" --- Sandra Schlotzhauer and Ramon Littell
"Step-by-Step Basic Statistics Using SAS: Student Guide and Exercises" --- Larry Hatcher

• SAS CERTIFICATION
SAS Certified Professional Program
SAS Certification Prep Guide: Base Programming for SAS 9, 3rd Edition --- SAS Institute
SAS Certification Prep Guide: Advanced Programming for SAS 9, 3rd Edition --- SAS Institute

• SOFTWARE
GET WINZIP (FREE EVALUATION VERSION)
GET ULTRAEDIT (SHAREWARE TEXT EDITOR)
GET METAPAD (FREE WINDOWS-BASED TEXT EDITOR)
GET NOTEPAD++ (FREE WINDOWS-BASED TEXT EDITOR)

QUESTIONS - Contact Mike Zdeb (msz03@albany.edu)
BACK TO MIKE ZDEB'S WEB PAGE