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.

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

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