Exporting Reports and Report Data

Export the Contents of an Entire Report
Export Data from a Graph
Export Data from a Geographical Map
Export Data from a List Table
Export Detail Data from a Crosstabulation Table
View Detail Data in a Crosstabulation Table

Export the Contents of an Entire Report

To export the entire contents of a viewed report, complete these steps:
  1. To create the zipped file that contains all the necessary reporting elements, perform one of these tasks:
    • From the Welcome window or Edit mode, select Filethen selectManage Files to access the File Management window.
      Next to any report that you want to export, click actions icon in the Actions column, and then select Export.
    • In View mode, select Filethen selectExport.
  2. When you are prompted, save the zipped file to a location such as your hard drive or a network drive.
  3. Extract the report files to a folder in a location such as your hard drive or a network drive.
    After the extraction, the folder contains the following contents:
    • sasExport_files contains the auxiliary files needed to display the report. You do not interact with the files in this folder.
    • sasExport.html enables you to open the report in a web browser.
    • sasExport.xls enables you to open the report in a Microsoft Excel spreadsheet.
      Note: When opening files in Microsoft Excel, you might receive a warning that the files are not in the expected location. Click Yes in the message box to acknowledge the warning.
    For advanced layout options when exporting entire reports (for example, selecting which tables and graphs to display), use SAS Add-In for Microsoft Office. For more information, see the online Help for SAS Add-In for Microsoft Office. If you do not have SAS Add-In for Microsoft Office, contact your on-site SAS support personnel.

Export Data from a Graph

To export data from a graph, complete these steps in View mode:
  1. Right-click in the graph and select Export Graph Data to open the Export dialog box.
    How the Export Dialog Box for Graphs Appears for Exporting to Microsoft Excel
    Export dialog box for graphs with the export to Microsoft Excel option selected
  2. Choose one of the following export options:
    • With the Export to radio button selected, choose the Excel option to export the graph data to a Microsoft Excel spreadsheet.
    • With the Export to radio button selected, choose the Word option to export the graph data to a Microsoft Word document.
    • Select the Save as radio button. Then select either Tab separated values (.tsv) file or Comma separated values (.csv) file to create a data file.
  3. Click OK.
  4. When you are prompted, choose either to open the file or to save it.

Export Data from a Geographical Map

To export data from a geographical map, complete these steps in View mode:
  1. Click export icon on the map toolbar to open the Export dialog box.
  2. Choose one of the following export options:
    • With the Export to radio button selected, choose the Excel option to export the graph data to a Microsoft Excel spreadsheet.
    • With the Export to radio button selected, choose the Word option to export the graph data to a Microsoft Word document.
    • Select the Save as radio button. Then select either Tab separated values (.tsv) file or Comma separated values (.csv) file to create a data file.
  3. Click OK.
  4. When you are prompted, choose either to open the file or to save it.

Export Data from a List Table

To export data from a list table, complete these steps in View mode:
  1. Right-click in the list table and select Export Table to open the Export dialog box.
    How the Export Dialog Box for List Tables Appears for Exporting to Microsoft Excel
    Export dialog box for list tables with the export to Microsoft Excel option selected
  2. Choose one of the following export options for rows:
    • Select the All Rows radio button to export all rows.
    • Select the Rows radio button to specify a range of rows to export. Enter a number in the From and To fields.
  3. Choose one of the following export options for columns:
    • Select the All columns radio button to export all columns.
    • Select the Selected columns radio button to specify which columns to export. Then select the check box to the left of the column or columns that you want to export. You can use up arrow icon or down arrow icon to change the order of the selected columns.
  4. If you select the Export to radio button, then choose one of the following options:
    • Select Excel (*.xlsx) to export the table data to a Microsoft Excel spreadsheet.
    • Select Excel (*.xls) to export the table data to a Microsoft Excel spreadsheet.
    • Select Word (*.doc) to export the table data to a Microsoft Word document.
  5. If you select the Save as radio button, choose one of the following options:
    • Select Tab separated values (.tsv) file to create a data file for Notepad.
    • Select Comma separated values (.csv) file to create a data file for Microsoft Excel.
  6. Click OK.
  7. When you are prompted, choose either to open the file or to save it.

Export Detail Data from a Crosstabulation Table

Note: If you want to see the detail data before you export it, then see View Detail Data in a Crosstabulation Table.
To export detail data from a crosstabulation table, complete these steps in View mode:
  1. Right-click in the crosstabulation table and select Export Table to open the Export dialog box.
    How the Export Dialog Box for Crosstabulation Tables Appears for Exporting to Microsoft Excel
    Export dialog box for crosstabulation tables with the export to Microsoft Excel option selected
  2. Choose one of the following export options for rows:
    • Select the All Rows radio button to export all rows.
    • Select the Rows radio button to specify a range of rows to export. Enter a number in the From and To fields.
  3. If you select the Export to radio button, then choose one of the following options:
    • Select Excel (*.xlsx) to export the table data to a Microsoft Excel spreadsheet.
    • Select Excel (*.xls) to export the table data to a Microsoft Excel spreadsheet.
    • Select Word (*.doc) to export the table data to a Microsoft Word document.
  4. If you select the Save as radio button, choose one of the following options:
    • Select Tab separated values (.tsv) file to create a data file for Notepad.
    • Select Comma separated values (.csv) file to create a data file for Microsoft Excel.
    You can also select (or deselect) the following check boxes related to the Save as option:
    • Specify Formatted data to save formatted data in the data file.
    • Specify Repeat row labels if expanded to repeat row labels for expanded levels in the data file.
  5. Click OK.
  6. When you are prompted, choose either to open the file or to save it.

View Detail Data in a Crosstabulation Table

Note: You cannot view detail data in a crosstabulation table if the data source has not been set up to support this feature by your data source administrator. In addition, whether the columns show the column label or the column name is controlled by a system administrator.
To view detail data in a crosstabulation table before you export it, complete these steps:
  1. Perform one of these tasks to open the View Detail dialog box:
    • To see the detail data behind a value in a crosstabulation table, click the value (which will be underlined).
      Note: If report linking has been enabled for the values in the crosstabulation table, then when you click on a value, you are prompted either to view detail data or to follow the report link.
    • To see the detail data behind a row or a column in a crosstabulation table, click the row or column heading in the innermost hierarchy level in the row or column and then select Show Detail Data.
      View Detail Option for the Sales Cost Column
      View Detail Option for the Sales Cost Column
  2. In the View Detail dialog box, you can review the data by selecting either Show column labels or Show column names.
    You can also click Export to export the data.
    View Data Dialog Box for a Crosstabulation Table
    View Data Dialog Box for a Crosstabulation Table
  3. Click Close Window to return to the report.
Copyright © SAS Institute Inc. All Rights Reserved.