The GENMOD analysis of the above example would be the following. No WEIGHT statement (or ZERO option) is needed. But with this modeling approach, one of the parameters - the one for the level with zero count - is infinite. For the level without the zero count, a confidence interval is provides but is wider than the intervals from PROC FREQ. The nonmodeling approach provided by PROC FREQ avoids parameter estimation and the exact analysis provides good estimates and confidence intervals for both levels.    data b; input t c; tr=20; off=log(tr); datalines; 1 0 0 10 ; proc genmod; class t; model c=t/d=p offset=off; lsmeans t / ilink cl; run; ... View more

Here's a different approach that should work for files created using the SAS ODS Excel destination and also those created by Excel.   Vince DelGobbo SAS R&D   filename xl zip '<path-to-file>\<filename>.xlsx' member='docProps/core.xml'; filename tempxml temp; data _null_; infile xl; file tempxml; input; put _infile_; run; filename tempmap temp; libname tempxml xmlv2 automap=replace xmlmap=tempmap; %symdel CREATEDBY MODIFIEDBY / nowarn; data _null_; set tempxml.coreProperties; call symputx('CREATEDBY', creator); call symputx('MODIFIEDBY', lastModifiedBy); run; %put _GLOBAL_; ... View more

Add after the end proc document an options line:   Proc document ... ... run; OPTIONS PAGENO=1;     ... View more

Hi, You might want to open a track with Tech Support. I believe that you might need to repaginate the document after you open it in Word, to get the page numbers to behave correctly. cynthia ... View more