Display the Historical and Predicted Rate Values in a Line Plot

Now, you want to create a line plot of the historical data and the calculated values.
  1. In the Basic Forecasting worksheet, select the Excel data.
  2. On the SAS tab, click Tasks and select Graphthen selectLine Plot. The Choose Data dialog box appears.
  3. For the input data source, select Excel Data. Because you previously selected the data, the range of data appears in the Excel Data box. In this example, the range of the Excel data is A4:B28.
  4. For the location of the results, select Existing worksheet. Then click Button that enables you to select a cell or range in an Excel worksheet and select the location of the output. In this example, the output is placed in cell A3.
    After completing these steps, the content in your Choose Data dialog box should look similar to this display:
    Contents of the Choose Data dialog box
    Click OK. The Line Plot task appears.
  5. In the Line Plot panel, select Line Plot.
    Line Plot selected in the Line Plot panel
    In the selection pane, click Data.
  6. In the Data panel, assign Date to the Horizontal role, and assign Rate to the Vertical role.
    Data panel with columns assigned to the task roles
    In the selection pane, click Chart Area.
  7. In the Chart Area panel, select gray as the background color of the chart.
    Specify the background color in the Chart Area panel
    In the selection pane, click Titles.
  8. In the Titles panel, change the title of the line plot and remove the generated footnote.
    To change the title of the line plot:
    1. In the Section box, select Graph.
    2. In the Text for section: Title area, clear the Use default text check box. Replace Line Plot with Simulated Federal Reserve Rate.
    To remove the footnote:
    1. In the Section box, select Footnote.
    2. In the Text for section: Footnote area, clear the Use default text check box. Delete the generated text that appears in the text box.
    Contents of the Titles panel after you change the title of the graph to Simulated Federal Reserve Rate
    Click Run.
    The new line plot appears in the Basic Forecasting worksheet. The output from the Line Plot task is larger than the single cell that you specified in the Choose Data dialog box. Therefore, the SAS add-in shifted the Excel data to the right to make room for the line plot.
    Line plot and input data in the Basic Forecasting worksheet
Copyright © SAS Institute Inc. All rights reserved.