topic Re: ODS html in ODS and Base Reporting

ODS html

deleted_user — Thu, 30 Mar 2006 20:43:47 GMT

Hi, I'm new to using ods html, and I was wondering if someone could help me. The user enters a valid PROC SQL statement, and the dispatcher program takes it and display it to a html output page. Right now, when the SQL statement returns no result, the HTML output page is blank. How can I display a message on the HTML output page telling the users that no output returned from the query they requested, instead of having just a blank page?

Any help is appreciated. Thanks!

Re: ODS html

1162 — Thu, 30 Mar 2006 21:25:42 GMT

Here's one suggestion.

Before starting your ods html statement, use a sql statement to count the number of records returned and pass that count into a macro variable. For example:

proc sql noprint;
select count(a) into :sqlcnt
from work.data;
quit;

Then I would add a title to my html report that goes something like:

title2 "Number of records returned: &sqlcnt";

When your SQL query returns no records, you'll still get the title that says no records returned.

Re: ODS html

David_SAS — Fri, 31 Mar 2006 15:49:59 GMT

ODS tries not to generate output containing no output objects (tables, graphs, text) in the body of the document. I would expect the SQL job to produce no HTML output.

A slight modification should work. Instead of a TITLE statement, use an ODS HTML TEXT= statement.

-- David Kelley, SAS
Message was edited by: David@SAS at Mar 31, 2006 10:50 AM

Re: ODS html

Cynthia_sas — Wed, 05 Apr 2006 17:20:57 GMT

Are you by any chance using SAS/IntrNet and/or htmSQL??? I wondered because usually when you use the dispatcher program, you are using SAS/IntrNet. Generally, you can code something in your dispatcher program to return a message to _webout using data _null_ or ODS TEXT=. If you are using SAS/IntrNet, look at this example that displays a message when there is an invalid attempt to login:
http://support.sas.com/rnd/web/intrnet/dispatch/sesssamp.html
Cynthia