SAS Tips and Tricks

Create CSV with Data Step

Creating CSV from SAS can be done in Data Step, Proc export or using ODS CSV. When CSV are not simple line of records, it becomes impossible to use this technic and Data Step programming is required.

Details

In this tips and tricks, we will first have a look to the ODS CSV and Proc export, those technics can indeed solve lot of problems easily. Then we will dive into Data Step programming and see how we can programmatically :

  • Create a CSV with comma delimited values
  • Add a header to the file to display the variable names,
  • Add footer to the file to display the number of records and end of file instructions
  • Create CSV with timestamp or write at the end of existing CSV
  • Add format to the values of the CSV

Prerequisites

You have some SAS experience and would like to use the flexibility of the Data Step to create CSV files.

Quick Facts

  • Scheduled date: Session not yet scheduled.
  • Duration :3 Hours
  • Fee :240 Euros (VAT Exclusive)
  • Language: French/English
  • Included: Coffees, tips and tricks material

Christophe Kabacinski

click here to get more information about this teacher.

Course Location

This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles


Go back to your selection