Hi Hoff, Are you limited to only using proc export? You could use the PC File Server Libname in the following. Unfortunately this method does not allow you to replace an existing table, so you need to perform a delete before each export. I am running Win7 64-bit with a 32-bit MS Excel installation and it works perfectly. LIBNAME XLSFILE PCFILES TYPE=EXCEL PORT=8621 SERVER=LOCALHOST SSPI=NO TYPE = EXCEL VERSION = 2007 PATH = "E:\CLASS.XLSX" MSENGINE = ACE; PROC DATASETS LIBRARY = XLSFILE; DELETE "CLASS$"N CLASS; RUN; DATA XLSFILE.CLASS; SET SASHELP.CLASS; RUN; PROC DATASETS LIBRARY = XLSFILE; DELETE "CLASS$"N CLASS; RUN; DATA XLSFILE.CLASS CLASS2; SET SASHELP.CLASS; AGE=AGE*2; RUN; PROC DATASETS LIBRARY = XLSFILE; DELETE "CLASS$"N CLASS; RUN; DATA XLSFILE.CLASS; SET SASHELP.CLASS CLASS2; RUN; LIBNAME XLSFILE CLEAR;
... View more
