Book Image

SAS for Finance

By : Harish Gulati
Book Image

SAS for Finance

By: Harish Gulati

Overview of this book

SAS is a groundbreaking tool for advanced predictive and statistical analytics used by top banks and financial corporations to establish insights from their financial data. SAS for Finance offers you the opportunity to leverage the power of SAS analytics in redefining your data. Packed with real-world examples from leading financial institutions, the author discusses statistical models using time series data to resolve business issues. This book shows you how to exploit the capabilities of this high-powered package to create clean, accurate financial models. You can easily assess the pros and cons of models to suit your unique business needs. By the end of this book, you will be able to leverage the true power of SAS to design and develop accurate analytical models to gain deeper insights into your financial data.
Table of Contents (9 chapters)

Role of autocorrelation

One of the assumptions for ordinary least squares regression is that the error terms are independent. However, with time series data, much of the time, the error terms are correlated. This is also known as autocorrelation. The regression tests performed up until now don't test for autocorrelation. If autocorrelation is present in the model, then the parameter estimates may not be accurate, and the standard error estimates will be biased.

While the AUTOREG procedure should ideally be used for regressing time series data, we can still try to evaluate the model for autocorrelation by using PROC REG, which was used earlier. The statistic that is going to help us explore the autocorrelation is the Durbin-Watson (DW) statistic.

The PROC REG code for autocorrelation is as follows:

PROC REG DATA=build; 
ID date; 
MODEL basket_index eps p_e_ratio global_mkt_share...