Now that you have access to the input data source, you
can start your analysis.
-
On the
SAS tab,
click
Tasks and select
DescribeSummary Statistics Wizard. The
Choose Data dialog
box appears.
-
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.
-
For the location of
the results, select
New worksheet. Change
the name of this worksheet to
Summary Statistics
Click
OK.
The Summary Statistics Wizard appears.
-
In step 1 of the wizard,
verify that you have selected the data source that you want to use.
Click
Next.
-
In step 2 of the wizard,
assign the VALUE variable to the
Summary statistics of
(Analysis variable) role.
-
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.
Notice that the style
of the results does not match your corporate style.