Using Proc Export

1
Using Proc Export
2
EXCEL

• PROC EXPORT DATAWork.myfile
• OUTFILEC\temp\example.xls
• DBMSEXCEL2000
• REPLACE
• SHEETMy Sheet
• RUN

If the name of dataset is not specified on DATA
the most recently created SAS dataset is used. If
SHEET is not included then a sheet name based on
DATA will be created, in this case a sheet named
myfile
3
No Donkeys Only Chickens

4
ACCESS
PROC EXPORT DATAWork.myfile OUTTABLEMy ACCESS
Table DBMSACCESS2000 REPLACE DATABASEC\tem
p\mydatabase.mdb RUN

If the database has a password then you can add
security access statements.
5
DLM

• PROC EXPORT DATAwork.myfile
• OUTFILEC\temp\myfile
• DBMSDLM
• DELIMITER/
• RUN

Various characters can be used as the Delimiter
?, , !,, etc. The file created can then be
opened by any text editor software or input
into Excel.
6
Other Options

• DBMS
• Can be ACCESS97, ACCESS2000, ACCESS2002,
  ACCESSCS, CSV, DBF, EXCEL4, EXCEL5, EXCEL97,
  EXCEL2000,JMP, PCFS, TAB, WK1, WK3, WK4