Sample PROC Export procedure to export a SAS dataset to CSV:
proc export data=work.DATASET_NAME;
outfile='c:\users\public\EXPORTED_FILE_NAME.csv'
replace
dbms=dlm;
delimiter=',';
run;
Sample DATA Step to export a SAS dataset to CSV:
proc export data=work.DATASET_NAME;
outfile='c:\users\public\EXPORTED_FILE_NAME.csv'
replace
dbms=dlm;
delimiter=',';
run;
Sample DATA Step to export a SAS dataset to CSV:
data _null_;
set work.DATASET_NAME;
file 'c:\users\public\EXPORTED_FILE_NAME.csv' dlm=',';
put var1 var2 var3;
run;
The above two statements are essentially equivalent, with two exceptions: the data step does not output field names to the CSV file, and the data step requires that desired variables be explicitly included in the
PUT statement.
set work.DATASET_NAME;
file 'c:\users\public\EXPORTED_FILE_NAME.csv' dlm=',';
put var1 var2 var3;
run;