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:
-
On the SAS tab,
click Tools, and then select Options.
-
Click Results to
view the results options.
-
Select the Show
Preview Changes dialog box check box, and 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.