/******************************************* This command file shows how to write out data using SAS. filename: write_data.sas ********************************************/ libname sasdata2 "c:\temp\sasdata2"; data iris; set sasdata2.iris; run; /*WRITE RAW DATA SEPARATED BY BLANKS*/ data _null_; set iris; file "c:\temp\iris.dat"; put sepallen sepalwid petallen petalwid species; run; /*WRITE RAW DATA SEPARATED BY TABS*/ data _null_; set iris; file "c:\temp\iris.txt" dlm="09"X; put sepallen sepalwid petallen petalwid species; run; /*WRITE RAW DATA SEPARATED BY COMMAS*/ data _null_; set iris; file "c:\temp\iris.csv" dlm=","; put sepallen sepalwid petallen petalwid species; run; /*WRITE RAW DATA INTO SPECIFIED COLUMNS*/ data _null_; set iris; file " c:\temp\iris_column.dat"; put species 1-10 sepallen 12-15 sepalwid 17-20 petallen 22-25 petalwid 27-30; run; /*A SHORTCUT WAY TO WRITE OUT DATA IN COLUMN LOCATIONS*/ data _null_; set iris; file "c:\temp\iris_column2.dat" ; put (sepallen sepalwid petallen petalwid) (4.) @18 species $10.; run; /*Export data to Excel*/ PROC EXPORT DATA= WORK.IRIS OUTFILE= "C:\temp\iris.xls" DBMS=EXCEL REPLACE; SHEET="sheet1"; RUN;