For
this example, you are researching the trend of the Federal Reserve
rate from January 1962 to May 2010. The data is publicly available
from
http://www.federalreserve.gov, which is the Web site for the Board of Governors of
the Federal Reserve System.
After completing this
example, you will know how to perform these tasks:
-
run a SAS analysis (specifically,
the Summary Statistics, Linear Regression, and Line Plot tasks) in
Microsoft Excel
-
specify Excel data as the input
data source for a SAS task
-
select the location of the output
from a SAS task
-
change the properties of the generated
output
-
quickly refresh your results by
including Visual Basic code in your Excel worksheet