Splitting a data table into multiple sheets of an Excel workbook
Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.
Tag: SAS Programming
Use functions in a WHERE statement to filter observations
Many people know that you can use "WHERE processing" in SAS to filter observations. A typical use is to process only observations that match some criterion. For example, the following WHERE statement processes only observations for male patients who have high blood pressure: WHERE Sex='Male' & Systolic > 140; In
Automating Excel workbooks creation using SAS
Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.