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:
  1. In the Original Data worksheet, select the Excel data.
  2. On the SAS tab, click Tasks. The Tasks window appears.
    Tip
    By default, the Tasks window stays open when you run a task, so unless you closed the Tasks window, it should still be open in Microsoft Excel. For the SAS add-in to automatically close this window every time you open a task, click Tools, and then select Options. Click Tasks to view the task options, and then select the Close task browser when opening a task check box.
  3. In the Tasks window, click Browse. In the search field, enter Linear Regression. From the list of results, select Linear Regression.
    Linear Regression Task in the Tasks Window
    The Choose Data dialog box appears.
  4. For the input data source, select Excel data. By default, the input data source is the range of Excel data in the Original Data worksheet. You can also use Button that enables you to select a cell or range in an Excel worksheet to select the input data.
  5. For the location of the results, select Existing worksheet, and then click Button that enables you to select a cell or range in an Excel worksheet. The SAS Add-In dialog box appears.
  6. In the Summary Statistics worksheet, select cell G1. In the SAS Add-In dialog box, click OK.
    After completing these steps, the content in your Choose Data dialog box should look similar to the following display:
    Choose Data Dialog Box for the Linear Regression Task
    Click OK. The Linear Regression task appears.
  7. In the Data panel, assign the VALUE variable to the Dependent variable role.
    Data Panel in the Linear Regression Task
    In the selection pane, click Titles.
  8. In the Titles panel, select Footnote, and then clear 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, the results from the Linear Regression task automatically use the Seaside style.
    Final Contents of the Summary Statistics Worksheet
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: April 27, 2017