Exporting Data from Report Objects

Export Data from a List Table

To export data from a list table:
  1. If not already selected, select the list table that you want to update.
  2. Right-click in 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 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.
  4. 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. 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 the Export to radio button, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select the Save as radio button, 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 not already selected, select the crosstab that you want to update.
  2. Right-click in 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 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.
  4. 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. 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 the Export to radio button, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select the Save as radio button, 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 report object, because only the data can be exported.
To export data from a graph:
  1. If not already selected, select the graph that you want to update.
  2. Right-click in 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 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.
  4. 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. 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 the Export to radio button, then the only option is Excel 2007 Workbook (*.xlsx) to create a Microsoft Excel spreadsheet.
  7. If you select the Save as radio button, 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.