Overview

In SAS Web Report Studio, if a prompt does not return any results, you are presented with an empty report. This sample shows you how to provide an informative message when no results are returned.

About the sample

This sample uses an information map that was created using the data set SASHELP.CLASS. You can use your own data to follow along.

This sample involves using a stored process to preprocess the data for the information map. The sample assumes that you have an understanding of SAS programming because the code is not explained in detail.

You can submit the code in an interactive Base SAS® session or in a SAS® Enterprise Guide program node. Use whichever application you are most comfortable with.

This sample was written using the second maintenance release for SAS 9.2 (TS2M2).

Create a variable to track results

The following sample code adds two variables named Date and Message to a table named mydates that is based on SASHELP.CLASS. The first observation (_N_) is set to the current date. The date is then incremented by 1 for each record. Modify the code for your environment, and then submit it.

LIBNAME Orion BASE "C:\Orion\date";
        
          data Orion.mydates;
          length message $60;
          set sashelp.class;
          retain date;
          if _n_ = 1 then 
          date = today();
          
          date = date + 1; 
          format date date7.; output;
          run;

Create and test the stored process

The following stored process code takes input from a prompted macro called Indate.

LIBNAME Orion BASE "C:\Orion\data";

libname biout (work);
%global indate;
        
        /* See if any rows are returned when subsetting on prompted date */
        /* A macro called rownum is created that contains  
           the number of rows returned */ 
        proc sql; 
          select count(*) into: rownum
          from orion.mydates (where=(date = "&indate"d));
          quit;
        /* Create a macro that check the value of rownum */ 
          %macro checkit(row);
        %if &rownum >= 1 %then
          %do;
          data biout.mydate;
          set orion.mydates (where=(date = "&indate"d));
          run;
          %end;
          %else
          %do;
          data work.mydate;
          set Orion.mydates (obs=1);
          Name='';
          Sex='';
          Age=.;
          Height=.;
          Weight=.;
          Message = "The date was invalid. No rows were returned";output;
          run;
          
          %end;
          %mend checkit;
       options mprint symbolgen;
        /* execute the macro, passing in the number of rows */
          %checkit(&rownum);
          run;
        %stpend;

Create an information map that uses the stored process

Using the stored process created previously, follow the instructions in Sample 39432: Associating an existing SAS Stored Process with an information map in SAS Information Map Studio 4.2 .

Create the report

1. Log in to SAS^® Web Report Studio, and select the information map that you created previously.
2. Insert a list table as the first object in the report. Add only the Message data item to columns.
3. Beneath the first table, insert another list table that contains the rest of the data items in the information map.
4. View the report, and experiment with valid dates and invalid dates. Following are some sample results.

Figure 1. Valid date displays a title in the message box

Additional Documentation

For more information about SAS Information Map Studio, see the SAS Information Map Studio documentation page.

For more information about stored processes, see SAS 9.2 Stored Processes: Developer's Guide.

For more information about SAS Web Report Studio, see the SAS Web Report Studio documentation page.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information