Date:         Wed, 26 Jul 2006 02:13:55 -0700
Reply-To:     Gaetan <gaetan.soulas@IFEN.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gaetan <gaetan.soulas@IFEN.FR>
Organization: http://groups.google.com
Subject:      Title with ods tagsets
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hello,

I am French and I have a problem with the new ODS "ods tagsets" :

I do a PROC REPORT with "TITLE "report"" in an ODS TAGSETS.

In my SAS output, I see the title but in my EXCEL file , the title is
not writen.

I don't know why !!!

My SAS program :


proc template;

   define style Styles.newstyle2;

      style header "Entête de colonne" /

         font = ("Arial",3,Italic)

         background = white

         foreground = black;

      style Systemtitle "Titre" /

         font = ("Arial",3,Italic)

         background = red

         foreground = black;

      style Data "Données dans cellules" /

         font = ("Arial",4)

         background = red

         foreground = black
                 Borderwidth=7
                 Bordercolor=cxb5a642;
end;

run;


title; footnote;

  *;
  *  Illustrate the use of split characters and column justification.
  *  Use WIDTH_FUDGE= to get slightly wider columns.
  *;

  ods listing close;

  ods tagsets.excelxp file='C:\report.xls' style=Styles.Newstyle2
options(width_fudge='0.8');

  proc print data=sashelp.class noobs label split='*';
     var name          / style={just=r};
     var age sex       / style={just=c};
     var height weight / style={just=l};
     label name   = 'Student*Name'
           age    = '*Age'
           sex    = '*Gender'
           height = 'Height*(inches)'
           weight = 'Weight*(pounds)';
title "print";
  run; quit;

  *;
  *  PROC REPORT is not setting column widths.  So we must force them
with
  *  DEFAULT_COLUMN_WIDTH=.  Reset WIDTH_FUDGE= to the default value of
"0.75".
  *;

  ods tagsets.excelxp options(default_column_width="7.5, 7.5, 5, 7.5,
7.5" width_fudge='0.75');

  proc report data=sashelp.class nowindows split='*';
     column  name sex age height weight;
     define  name   / display   'Student*Name'     left
style={just=l};
     define  sex    / display   '*Gender'          right
style={just=r};
     define  age    / display   '*Age'             center
style={just=c};
     define  height / display   'Height*(inches)'  center
style={just=c};
     define  weight / display   'Weight*(pounds)'  center
style={just=c};
         title "report";

  run; quit;

  ods tagsets.excelxp close;

Thank you for your help !!

  ods listing;