Generate the Summary Statistics for the Federal Reserve Data

Now that you have access to the input data source, you can start your analysis.
  1. On the SAS tab, click Tasks and select Describethen selectSummary Statistics Wizard. The Choose Data dialog box appears.
  2. For the input data, select Excel Data and specify the range of the Excel data in the Original Data worksheet.
    Tip
    If your input data source is selected in Excel, then the SAS add-in automatically lists this range in the Excel Data box.
  3. For the location of the results, select New worksheet. Change the name of this worksheet to Summary Statistics
    Choose Data dialog box with the Excel Data and New Worksheet options selected
    Click OK. The Summary Statistics Wizard appears.
  4. In step 1 of the wizard, verify that you have selected the data source that you want to use. Click Next.
  5. In step 2 of the wizard, assign the VALUE variable to the Summary statistics of (Analysis variable) role.
    Data panel in the Summary Statistics task
    Click Next.
  6. In step 3 of the wizard, click Next to generate the default summary statistics.
    In step 4 of the wizard, delete the text for the footnote, and then click Finish.
    The results open in a new worksheet called Summary Statistics.
    Initial results from the Summary Statistics task
    Notice that the style of the results does not match your corporate style.