topic Re: Fit to page width in ODS TAGSETS.EXCELXP in ODS and Base Reporting

Fit to page width in ODS TAGSETS.EXCELXP

Olivier — Wed, 11 Jun 2008 13:41:38 GMT

Hi all.
Something weird does happen when I use the ExcelXp tagset to display large tables. In fact, the weird thing is that it does not happen to behave like expected.
Il want to use the FIT_PAGEWIDTH option to resize automatically the output when printing, on a single page. The "printer setup" is correctly defined in Excel, but the radio button is not set, so any settings on page width or height are just ignored.
Am I wrong somewhere, or is there something missing there ?
Sample below :[pre]
DATA work.large ;
ARRAY columns (15) ;
DO i = 1 TO 100 ;
DO j= 1 TO DIM(columns) ;
columns(j)=RANNOR(0) ;
END ;
OUTPUT ;
END ;
RUN ;
ODS TAGSETS.EXCELXP FILE="c:\temp\large.xls" OPTIONS(PAGES_FITWIDTH="2") ;
PROC PRINT ;
RUN ;
ODS TAGSETS.EXCELXP CLOSE ;
[/pre]
Thanks in advance for any hint, help or suggestion.
olivier

Re: Fit to page width in ODS TAGSETS.EXCELXP

Cynthia_sas — Wed, 11 Jun 2008 16:12:48 GMT

Hi, Olivier:
I have never experimented with PAGES_FITWIDTH, but if you open a track with Tech Support, and this is a reproducible example; then the track will be handled by the folks who know how to fix the issue.

cynthia

Re: Fit to page width in ODS TAGSETS.EXCELXP

deleted_user — Mon, 16 Jun 2008 22:46:34 GMT

Consider using the FitToPages option. As in:
[pre]
ODS TAGSETS.EXCELXP FILE="c:\temp\large.xls" OPTIONS(PAGES_FITWIDTH="2" FitToPages="YES") ;
[/pre]

------------------------------------------------------------------------------
The following web-page was helpful to me at the time of this post.
http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html

Also using ...
[pre]
ODS TAGSETS.EXCELXP OPTIONS( doc="help" );ODS TAGSETS.EXCELXP close;
[/pre]
...will output useful help documentation to the log stream.

I really find TAGSETS.EXCELXP helpful. I'm thankful to those whom have worked on this.

Re: Fit to page width in ODS TAGSETS.EXCELXP

Eric_SAS — Wed, 18 Jun 2008 13:43:18 GMT

Change your ods statement to this.

ODS TAGSETS.EXCELXP FILE="large.xls" OPTIONS(PAGES_FITWIDTH="2" FitToPage="YES") ;

It would be nice if the FitToPage option would turn on if a FitWidth or Height were given, I will add that in a future release of the tagset.