Hi Joe,

Thanks for the response. Unfortunately, EXCEL can't be used with x64:

http://support.sas.com/kb/33/228.html

I also tried plugging in things like EXCEL5 but that doesn't work either.

Any other ideas?

Thanks again!

Ida

On Dec 14, 2:40 pm, snoopy...@GMAIL.COM (Joe Matise) wrote: > Why did you change the DBMS to XLS from EXCEL? That's the problem. XLS is a > different engine entirely, and does not work in the same manner as EXCEL. > > -Joe > > > > On Mon, Dec 14, 2009 at 8:27 AM, Ida <ihat...@hsph.harvard.edu> wrote: > > Hi, > > > I have just switched from 9.1.3 on x32 to 9.2 on x64, and now my > > exports are getting lost in translation. > > > I have created a code to run a bunch of analyses/queries and then > > export these results to a formatted excel workbook with multiple > > sheets. Each of 20 sheets has conditional formatting (e.g., if > > p<0.05, highlight in yellow). Previously, this excel formatting was > > upheld no matter how many times the sheets were overwritten with new > > data. Now, however, the sheets are overwritten and the excel > > formatting is lost. > > > Previous code: > > PROC EXPORT data=file > > OUTFILE=file.xls > > DBMS=EXCEL REPLACE; > > SHEET="mysheet"; > > run; > > > New code: > > same w/ DBMS=XLS instead of EXCEL > > > I have tried all sorts of other DBMS and VERSIONS, with no success > > (some won't run, others won't format, etc...) I will have to switch > > back to my x32 w/9.1.3 if this can't be resolved, which I'd really > > rather not do. > > > Any help would be greatly appreciated! > > > Thank you in advance!