The SAS Output Delivery System and reporting techniques

Fit to page width in ODS TAGSETS.EXCELXP

Reply
Super Contributor
Posts: 260

Fit to page width in ODS TAGSETS.EXCELXP

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
SAS Super FREQ
Posts: 8,868

Re: Fit to page width in ODS TAGSETS.EXCELXP

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
N/A
Posts: 0

Re: Fit to page width in ODS TAGSETS.EXCELXP

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.
SAS Employee
Posts: 95

Re: Fit to page width in ODS TAGSETS.EXCELXP

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.
Ask a Question
Discussion stats
  • 3 replies
  • 297 views
  • 0 likes
  • 4 in conversation