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 <ihatoum@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!
>

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=A0pm, snoopy...@GMAIL.COM (Joe Matise) wrote:
> Why did you change the DBMS to XLS from EXCEL? That's the problem. =A0XLS=
 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. =A0Each of 20 sheets has conditional formatting (e.g., if
> > p<0.05, highlight in yellow). =A0Previously, this excel formatting was
> > upheld no matter how many times the sheets were overwritten with new
> > data. =A0Now, however, the sheets are overwritten and the excel
> > formatting is lost.
>
> > Previous code:
> > PROC EXPORT data=3Dfile
> > OUTFILE=3Dfile.xls
> > DBMS=3DEXCEL REPLACE;
> > SHEET=3D"mysheet";
> > run;
>
> > New code:
> > same w/ DBMS=3DXLS 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!