Exporting Data from Report Objects

Export Data from a List Table

To export data from a list table:
  1. If the list table that you want to export is not already selected, select it.
  2. Right-click on the list table, and select Export <listTableName>, where <listTableName> is the name of the report object.
    Here is an example of the Export menu option for a list table:
    Export Menu for List Tables
    Export Menu for List Tables
    The Export or Save As window is displayed.
    Export or Save As Window for List Tables
    Export or Save As Window for List Tables
  3. Choose one of the following export options for rows:
    • Select All rows to export all rows.
    • Select Rows to specify a range of rows to export. Enter a number in the From and To fields.
  4. Choose one of the following export options for columns:
    • Select All columns to export all columns.
    • Select Selected columns to specify which columns to export. Then, select the check box (or check boxes) to the left of the column (or columns) that you want to export. At least one column is required. If you do not select a column, then a message is displayed, and the Export or Save As window cannot be closed.
  5. (Optional) To choose whether the exported data is formatted, either select or clear the Formatted data check box. This check box is selected by default.
  6. If you select Export to, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select Save as, choose one of the following options:
    • Select Tab-Separated Values (*.tsv) to create a data file.
    • Select Comma-Separated Values (*.csv) to create a data file.
  8. Click OK.
  9. When you are prompted, choose either to open the file or to save it.

Export Data from a Crosstab

To export detail data from a crosstab:
  1. If the crosstab that you want to export is not already selected, select it.
  2. Right-click on the crosstab, and select Export <crosstabName>, where <crosstabName> is the name of the report object.
    Here is an example of the Export menu option for a crosstab:
    Export Menu for Crosstabs
    Export Menu for Crosstabs
    The Export or Save As window is displayed.
    Export or Save As Window for Crosstabs
    Export or Save As Window for Crosstabs
  3. Choose one of the following export options for rows:
    • Select All rows to export all rows.
    • Select Rows to specify a range of rows to export. Enter a number in the From and To fields.
  4. Choose one of the following export options for columns:
    • Select All columns to export all columns.
    • Select Selected columns to specify which columns to export. Then, select the check box (or check boxes) to the left of the column (or columns) that you want to export. At least one column is required. If you do not select a column, then a message is displayed, and the Export or Save As window cannot be closed.
  5. (Optional) To choose whether the exported data is formatted, either select or clear the Formatted data check box. This check box is selected by default.
  6. If you select Export to, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select Save as, choose one of the following options:
    • Select Tab-Separated Values (*.tsv) to create a data file.
    • Select Comma-Separated Values (*.csv) to create a data file.
  8. Click OK.
  9. When you are prompted, choose either to open the file or to save it.

Export Data from a Graph

Note: You cannot export the actual visual graph. Only the data can be exported.
To export data from a graph:
  1. If the graph that you want to export is not already selected, select it.
  2. Right-click on the graph, and select Export <graphName>, where <graphName> is the name of the report object.
    Here is an example of the Export menu option for a line chart:
    Export Menu for Graphs
    Export Menu for Graphs
    The Export or Save As window is displayed.
    Export or Save As Window for Graphs
    Export or Save As Window for Graphs
  3. Choose one of the following export options for rows:
    • Select All rows to export all rows.
    • Select Rows to specify a range of rows to export. Enter a number in the From and To fields.
  4. Choose one of the following export options for columns:
    • Select All columns to export all columns.
    • Select Selected columns to specify which columns to export. Then, select the check box (or check boxes) to the left of the column (or columns) that you want to export. At least one column is required. If you do not select a column, then a message is displayed, and the Export or Save As window cannot be closed.
  5. (Optional) To choose whether the exported data is formatted, either select or clear the Formatted data check box. This check box is selected by default.
  6. If you select Export to, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select Save as, choose one of the following options:
    • Select Tab-Separated Values (*.tsv) to create a data file.
    • Select Comma-Separated Values (*.csv) to create a data file.
  8. Click OK.
  9. When you are prompted, choose either to open the file or to save it.
Copyright © SAS Institute Inc. All rights reserved.