SAS/IntrNet Application Dispatcher

Building a Basic Web Report

This sample demonstrates the process of building a basic Web report. At each step you can run the sample report and view the program that generated it. Checking the Show SAS Log box at the bottom of the page will show the input parameters and the SAS log of each program when you run it. After running or displaying a program use the browser back button to return to this page.

First, we begin with a simple HTML Sales Report. The program consists of just an ODS HTML statement and a simple PROC REPORT.

Then, we add a GIF graph to the Sales Report. The program now includes a PROC GCHART to create the graphic.

Or we can add a Java applet graph to the Sales Report by making simple changes to the GOPTIONS and ODS HTML statements in the program.

Next, we return to the original report and add drilldown links to the region column of the Sales Report. The program creates a temporary copy of the data set with a new drilldown link variable with HTML anchor tags added to the region name. Clicking on a drilldown link will display detail data for the region. The detail data report is created by a separate detail program.

Finally, we add the graph back to the Sales Report. Both the graph and the tabular report now contain drilldown links. The program now creates a temporary copy of the data set with two new variables: one for the tabular drilldown and one for the graph drilldown. The tabular drilldown value must contain the full HTML anchor tag with the HREF URL and with region name. The same detail program is used for the detail report.

Show SAS Log