Preview and Select the Results

Next, you want to analyze the correlation between population and violent crime. Depending on the options that you select, the Correlations task can generate multiple types of output, and you might not want all of this output included in an Excel worksheet. In the SAS Add-In for Microsoft Office, you can preview the results of a task or SAS job. Then you can select the output that you want to display in the Excel worksheet.
The preview functionality that is available with the SAS add-in is not turned on by default. To enable the preview functionality:
  1. On the SAS tab, click Tools, and then select Options. The SAS Options dialog box appears.
  2. Click the Results tab.
  3. In the General area, select the Show Preview Changes dialog box check box.
    The check box for the Show Preview Changes dialog box on the Results tab
    Click OK.
Now whenever you run a task, you can preview the results of the task before the results open in a Microsoft Excel worksheet.
Copyright © SAS Institute Inc. All rights reserved.