• Ekta Aggarwal

EXPORTING CSV , TXT and EXCEL files from SAS

In this tutorial we shall learn about how to export data from SAS using PROC EXPORT.

We will mainly focus on importing:

For this tutorial we are using SAS' inbuilt dataset SASHELP.SHOES for exporting.


Exporting a CSV file


PROC EXPORT DATA = SASHELP.SHOES 
OUTFILE = '/home/u50132927/My_datasets/My_exported_csv.csv'
DBMS = csv REPLACE;
RUN;

Using the above syntax we can export our CSV file from SAS. Following is the explanation of keywords in PROC EXPORT.


DATA : Library and file name which needs to be exported.

OUTFILE : Location and filename of the new file which will be saved.

DBMS = CSV (for CSV files)

REPLACE: Replace the already existing dataset. In our case if My_exported_csv.csv exists then that will be replaced by our new file.


Exporting an excel file


PROC EXPORT DATA = SASHELP.SHOES 
OUTFILE = '/home/u50132927/My_datasets/My_exported_xlsx.xlsx'
DBMS  = XLSX REPLACE;
RUN;

For exporting excel file we mention DBMS = XLSX or XLS (depending which version of MS-Office you are using)


We can also export various datasets in a single excel (each data in a single sheet) in SAS. To know more you can refer to this tutorial.


Exporting a TXT file

PROC EXPORT DATA = SASHELP.SHOES 
OUTFILE = '/home/u50132927/My_datasets/My_exported_txt.txt'
DBMS  = TAB REPLACE;
RUN;

For exporting a txt file we mention DBMS = TAB.

Tags: