Overview of SAS Web Report Studio

SAS Web Report Studio

SAS Web Report Studio

  • provides non-technical business users the ability to find, interact with, create, and share reports based on corporate data.
  • is designed to meet the specific needs, skills, and experiences of decision makers at all levels of the organization who need self-service information quickly
  • is intended for users with little or no experience in other reporting tools or database technology.

SAS Report Model

SAS®9 provides the ability to save output to the SAS Report Model format using the SAS Output Delivery System (ODS). SAS Web Report Studio will be able to view ODS output stored in the SAS Report Model XML format.


Users can interact with the report by performing operations such as drilling, sorting, filtering, ranking, exporting, and group break navigation using the Table of Contents. This is feasible because SAS Web Report Studio stores reports in the common SAS Report Model XML format.

Interaction with SAS Application Servers

SAS Web Report Studio can use any or all of the following application servers:


SAS Web Report Studio

Which browsers are supported?

  • Internet Explorer 5.5 or newer

Using SAS Web Report Studio

SAS Web Report Studio is started from your browser by entering a specific URL.

On the classroom machines you use:


The main window of SAS Web Report Studio includes links for

  • viewing an existing report
  • creating a new report
  • editing an existing report
  • setting preferences.


New reports can be created using the Report Wizard, which uses a point-and-click interface to gather information to build the report.


Another option for creating reports is the Report Builder, which allows the information for the report to be entered on one screen.


The below demonstration shows how to use SAS Web Report Studio to create a report.


  1. Open an Internet Explorer window and enter the following URL: http://localhost:8080/SASWebReportStudio
  1. Enter the user name and password provided by your instructor.


Select Screenshot_1705

After logging on, the main window of SAS Web Report Studio is displayed.


There are many options from the main window, including the ability to view an existing report, create a new report, and set SAS Web Report Studio preferences.

      3. Begin creating a new report by selecting Screenshot_1707


The default interface is the Report Wizard – you can switch to the Report Builder by selecting Screenshot_1710

Notice that this is the first of five steps to create a report.

To navigate between the steps, choose either Screenshot_1711 or Screenshot_1712

Step 1 of the Report Wizard – Select data for the report

      4. Select a data source for the report; select the information map Orion Star Gold Customer Order Information.


Select Screenshot_1714to display the Data Source Information window.


When a data source has been selected, the data items are displayed. Select the desired data items and use Screenshot_1716to move them to the Selected Data Items: list.

     5. Select the following fields:

  • Customer Age Group
  • Customer Country
  • Customer Gender
  • Total Retail Price for This Product.


Select Screenshot_1712to advance to the next step (step 2).

Step 2 of the Report Wizard – Sort or filter data (optional)

     6. Change the sort order to Ascending for the following columns:

  • Customer Age Group
  • Customer Country
  • Customer Gender.


If there are any filters in the information map they will be available in the filter box the data item(s) the filter is based on.


A new filter can be created by selecting Screenshot_1720for the selected data item, this opens the Create new filter window.


     7. Select Screenshot_1722to view the results of the query.

      8. The Preview Data window displays a listing of the query results:


Select Screenshot_1724to export the data to Microsoft Excel.

      9. Select Screenshot_1725to close the Preview Data window.

      10. Select Screenshot_1712to advance to the next step (step 3).

Step 3 of the Report Wizard – Create group breaks (Optional)

      11. Select Customer Gender as a Group break.


The default for group breaks is to have a new page for each value. This option produces a table of contents to navigate to each page of output.

Select Screenshot_1712to advance to the next step (step 4).

Step 4 of the Report Wizard – Select a table, graph, or both

Tables and graphs can be created for the desired report. If the Graph check box is not available, it is because a measure is not identified in the data.

      12. Select the Table check box (if not already selected).

          a. Enter Sales by  Gender,  Age,  and  Country as the Title for the Table.

      13. Select the Graph checkbox.

         a. Enter Retail Price  Analysis as the Title for the Graph.

         b. Select Pie for the graph type.

         c. Specify Total Retail Price for This Product as the variable to set the segment size.

         d. Specify Customer Age Group as the variable to set the segments.


Select Screenshot_1712to advance to the next step (step 5).

Step 5 of the Report Wizard – Define the header and footer

      14. Enter Orion Star  Marketing  Data  Mart as the Text for the Report header.


Select Screenshot_1712to exit the Report wizard and create the reports.

The report is displayed in the browser. Because the report is grouped by Customer Gender, a table of contents area is displayed on the left to enable users to page between the values.



Scroll to see both the graph and the table.

      15. View information for the next group by selecting Males in the Table of Contents.


Across the top of this report preview there are a set of buttons.

Modify Returns to Report wizard for modifications
Options Provides a choice to either left-align or center the report, and to choose between different styles for the report
Print Opens the print properties window
Save Allows report to be saved
Create New Invokes Report wizard to start on a new report

The icons at the top of each section provide additional functionality for the section.

Screenshot_1732 Edit options
Screenshot_1733 Export table/graph
Screenshot_1734 Table/graph information

Save the Report

      16. Select Screenshot_1735to save the report.

      17. Select My folders and specify Customer Sales  Analysis as the Report  name.


Select Screenshot_1737to save the report.

Copy the Report

      18. Select the Choose Report tab at the top of the Web Report Studio window, and then select My Folders.


      19. The Actions button to provides the ability to issue various commands for the selected report.


      20. Select the actions button Screenshot_1740 for the Customer Sales Analysis report and select Copy.

      21. In the Copy Report window, select Shared folders and then Reports.



Select Screenshot_1742to perform the copy.

      22. Choose Screenshot_1743to verify that the report was copied to this common report area.


     23. Select the actions button Screenshot_1745 for the Customer Sales Analysis report and select Rename.

      24. Type in Shared Customer  Sales  Analysis.


Select Screenshot_1742to rename the file.

The list of reports is displayed showing the new name of the report.


Change SAS Web Report Studio Preferences

      25. Select Screenshot_1748


      26. Select the Report Creation tab and supply default header text of Orion  Star  Marketing  Data  Mart.


Select Screenshot_1742

      27. Select Screenshot_1751to close out of SAS Web Report Studio.



0 Responses on Overview of SAS Web Report Studio"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.