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.
The
SAS Options dialog box appears.
-
-
In the
General area,
select the
Show Preview Changes dialog box check
box.
Now whenever you run
a task, you can preview the results of the task before the results
open in a Microsoft Excel worksheet.