SAS Helpful Hints

Introduction

Making the most of the PC Environment

• Preferences
• Clear Log and Output button
• Reset defaults
• Keyboard edit commands
• Sending output to Microsoft Word

Fun things to do in the Data step

• Operators
• Functions(Numeric, Date, Character)
• Arrays
• Carrying forward data(Retain)
• Inputing data quickly.

Error Checking

• Range checks
• Cross checks
• Duplicates

Formats and Informats(examples and usage)

• User Defined formats and informats
• SAS Numeric formats and informats
• SAS Date formats and informats
• SAS Time formats and informats
• Un-Formating Variables

Macros

• Language and Functions
• Biostat macro procedure library
  • Break string into printable pieces
  • Create a date from a character
  • End of the month
  • Parse a string, word by word
  • Randomization
  • StdDev/StdErr

Procedures

• Calendar
• Corr
• Cport/Cimport(transfering data)
• Freq
• Genmod
• Glm
• Gplot/Gchart
• Lifetest
• Plot
• Tabulate

Advanced Techniques(Mass Production Routines)

• Output Delivery System(ODS)
• Randomization
• Mass Production of Boxplots
• Mass Production of Standard Error Plots
• Chi-Squares
• Anovas
• Survival Analysis
• Ttests
• Kruskal-Wallis
• Auto Tabulate
• Adverse Event Summary
• %Change From Baseline(Chi-Square)
• Formating Proc Tabulate Output Nicely
• Last Observation Carried Forward
• Deriving visit numbers from windows
• Finding Outliers
• Data manipulation tools: Deltas and Transpose.
• Misc. Tidbits: (Html,Replay,mean(Std)).

Please send your comments and suggestions about this web page to A. Watts (watts@bst.rochester.edu)