This question might better be answered by opening a track with Tech Support. They could find out what version of SAS you are using and what your ODS HTML statements look like, whether you're using a CSS file, what your configuration is, etc, etc.
For example, if you were using SAS 8 and ODS HTML, the HTML file created could be quite large, because HTML 3.2 tags with embedded style information are the default HTML created. If on the other hand you are using SAS 9 and ODS HTML, the HTML file created may be smaller because the style information is included in an in-line style section in the HTML.
Other factors that Tech Support can check -- does your system hang when SAS and ODS are creating the file or does your system hang when the browser tries to open the file. Complicating factors include: are you using SAS Enterprise Guide, are you using stored processes on the SAS Enterprise Intelligence Platform, etc.
we are using sas 9.1 and I am using sas base ,when i tested the program for 5000 observation program ran perfectly and output is generated in html using proc report.I have also tested to sent the output in excel proc export,It worked perfectly but when out put is produced as html file it took lot of time to open the file and when it opened my sas session hung up.
Is there any limit on the number of observations we can send to html output?
Comparing PROC EXPORT to ODS HTML is like comparing apples and oranges. PROC EXPORT creates a true binary .XLS file. ODS HTML creates an HTML ASCII text file that is meant to be opened in a browser. The binary file created by PROC EXPORT for Excel is usually smaller than an ODS HTML file created from a PROC PRINT or PROC REPORT of the same data because ODS HTML output files have color and font information and PROC EXPORT (binary Excel files) do NOT have color and font information for the data.
Some folks -do- use ODS HTML to make HTML files that can be opened in Excel. Since it is not clear whether you are using ODS HTML to make a file that can be opened in the browser or to make an HTML file that can be opened in Excel, it is really hard to answer your question. Usually, the limit on the number of observations you can send to an HTML file is based on your system limitations.
For example, if I run this program (which makes 57,000 obs), I can open the HTML file on my system and SAS does not hang. It could be because I have a huge hard drive on my system. The HTML file is 10,295 KB in size. The PROC EXPORT step, however, creates a binary .XLS file that is 5,216 KB in size.
I still think this is an issue for Tech Support -- there are too many different factors that could be causing your session of SAS to hang.
*** make some big data;
do grpvar = 1 to 3000 by 1;
proc sort data=bigclass;
by grpvar name;
ods listing close;
** Apples...10,295 KB in size for HTML file;
ods html file='c:\temp\bigclass.html' style=sasweb;
proc report data=bigclass nowd;
column grpvar name age height weight;
STYLE=MINIMAL creates a small HTML file. In addition, the PHTML (plain HTML) destination only uses about 12 style elements and CHTML (compact HTML) destination only uses BOLD for the headers. So, if
ODS HTML file='...' style=minimal
makes too big a file, then ODS PHTML or ODS HTML should make significantly smaller files.