Advanced Search

Return to Snippet

Revision: 13629
at April 29, 2009 17:42 by statsplank
Initial Code 
/* Import from Excel */
PROC IMPORT OUT= test  
            DATAFILE= "D:\May08\Final.xls" 
            DBMS=EXCEL REPLACE; 
            SHEET="Final Data$"; 
            GETNAMES=YES; 
            MIXED=Yes; 
            SCANTEXT=YES; 
            USEDATE=YES; 
            SCANTIME=YES;
RUN;


/* Export to Excel */
PROC EXPORT DATA= P.FINAL_CALC 
            OUTFILE= "D:\Feb09\sas\Final.xls" 
            DBMS=EXCEL REPLACE;
RUN;
Initial URL 









Initial Description














Initial Title





Import from and Export to Excel









Initial Tags





excel









Initial Language





SAS