SAS ODS Output Incomplete

0
votes

I am trying to output to an excel workbook using ods. However, I am only getting some of the output. For example, the Summary Panel is not populating. The same code is working for some proc freq I did earlier. Also, how do I insert the TOC--I thought that was automatic.

Here is my code: 

ods _all_ close;

ODS TAGSETS.EXCELXP
file='\\psf\Home\Documents\ttest_750_091814.xls'
STYLE=Default
OPTIONS ( Orientation = 'landscape'
FitToPage = 'yes'
Pages_FitWidth = '1'
Pages_FitHeight = '100' );
ods graphics on;


proc format;
    value compF 0 = 'M'
                1 = 'F';    
run;

proc ttest data=ten;
    class comp;
    format comp compF.;
    var Sales;
    where id = "750";
run;

ods tagsets.excelxp close;
ods html close;
1
sas
What happens when you remove the FitToPage, Pages_FitWidth and Pages_FitHeight. – LonelySoul

1 Answers

0
votes

Table of Contents comes from one of two options set:

  • index='yes'
  • contents='yes'

They give somewhat different results, so try both and keep whichever you find more useful.

See Eric Gebhart's paper from SGF 2008 for more details.