Adding Results to an Existing Worksheet

Next, you want to perform a linear regression analysis and add the results to the Summary Statistics worksheet. To run a linear regression analysis:

In the Original Data worksheet, select the Excel data.
On the SAS tab, click Tasks and select RegressionLinear Regression. The Choose Data dialog box appears.
For the input data source, select Excel data. By default, the input data source is the range of Excel data on the Original Data worksheet. You can also use to select the input data.
For the location of the results, select Existing worksheet, and then click . In the Summary Statistics worksheet, select cell G1. In the Choose Location dialog box, click OK.

Note: If the button is not available, see Trust Access to the Object Model for a Visual Basic Project.

After completing these steps, the content in your Choose Data dialog box should look similar to the following display:

Click OK. The Linear Regression task appears.
In the Data panel, assign the VALUE variable to the Dependent variable role.

In the selection pane, click Titles.
In the Titles panel, select Footnote, and then deselect the Use default text check box. Delete the text in the Text for section: Footnote box.

Click Run.

The results from the linear regression analysis open in the Summary Statistics worksheet. Because Seaside was selected as the style for the results in the SAS Options dialog box, the results from the Linear Regression task automatically use the Seaside style.