Date:         Thu, 11 Jun 2009 03:09:17 -0700
Reply-To:     "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <rdevenezia@WILDBLUE.NET>
Organization: http://groups.google.com
Subject:      Re: Ods Html Files
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Jun 11, 3:05 am, ash007 <RamsamyAsh...@gmail.com> wrote:
> hello sas users,
>
> I need to create a HTML report with ODS HTML.
>
> But now SAS create a Html file each time there is a proc sql. Before
> SAS created only a filr HTML. But now several...

Very unusual when things change spontaneously.  What host, and of
version of SAS?
   %put &SYSSCP &SYSSCPL &SYSVER &SYSVLONG;

A new 9.2 ODS HTML option is NEWFILE=
  NEWFILE=PAGE or
  NEWFILE=PROC
can cause the behavior you are observing.

Is it possible this option was turned on earlier in the code flow ?
--------
ods html newfile=proc;
ods html file="C:\temp\controle_mntCotisation.html" style=sasweb;

title "Class_1";
proc sql;
  select * from sashelp.class;
quit;

title "Class_2";
proc sql;
  select * from sashelp.class;
quit;

title "Class_3";
proc sql;
  select * from sashelp.class;
quit;

title "Class_4";
proc sql;
  select * from sashelp.class;
quit;

ods html close;
--------

There is a possibility of a 'wonky' session.
  Does it happen in a fresh interactive SAS session ?
  Does it happen if submitted in batch mode ?
  Does it happen after a system reboot (if windows) ?

>
> this is my code :
>
> ODS HTML FILE = "C:\temp\controle_mntCotisation.html" style = sasweb;
>
> title 'MNT COTISATION  - M_import';
> proc sql;
> select sum(MNT_COTISATION)  AS  COT_MNT_COTISATION,
> .....
> ;
> QUIT;
>
> title 'MNT COTISATION - M_transc';
> proc sql;
> select sum(COT_MNT_COTISATION)  AS  COT_MNT_COTISATION,
> ......
> ;
> QUIT;
...
>
> ash007.