Updated February 6, 2009
EPI 697 (ADVANCED TOPICS IN SAS)
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
QUESTIONS - Contact Mike Zdeb (
msz03@albany.edu
).
BACK TO MIKE ZDEB'S WEB PAGE