Date: Mon, 14 Dec 2009 17:06:12 -0800
Reply-To: Savian <savian.net@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Savian <savian.net@GMAIL.COM>
Subject: Re: PROC EXPORT excel formatting in SAS 9.2 on x64
Content-Type: text/plain; charset=ISO-8859-1
On Dec 14, 7:27 am, Ida <ihat...@hsph.harvard.edu> wrote:
> 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
> DBMS=EXCEL REPLACE;
> 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!
SaviCells (not SaviCellsPro) can handle it for you. Download it here:
or on sasCommunity.org. Documentation is also on sasCommunity.org