Centers for Disease Control and Prevention 1600 Clifton Rd. Atlanta, GA 30333, USA
800-CDC-INFO (800-232-4636) TTY: (888) 232-6348, 24 Hours/Every Day - cdcinfo@cdc.gov

CDC Home

PROC EXPORT Syntax

PROC EXPORT is a SAS-code based alternative to

the Export Wizard.  

 

PROC EXPORT DATA= datasetname

             OUTFILE= “location and file name.XLS"

             DBMS=EXCEL REPLACE;

      SHEET=“excel worksheet name";

RUN;

Will replace existing excel files (with same name) This will allow the user to run the program multiple times to update data.

For Excel files must end in xls.