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)

Data preparation for MBA

The time series data was transformed to ensure that each row of data represented the customer's purchase basket. A sample of 500 active customers was selected for the analysis. The definition of active stipulated that the customer had used at least one product or service in the last 12 months and had at least one open product at the time of selection. Only customers with multiple products/services were chosen for the analysis.

The following is a snapshot of the customer data used for modeling:

Custid

Pr1

Pr2

Pr3

Pr4

Pr5

1

Residential_Mortgage

Insurance

Personal_Current_Account

Savings_Account

Premium_Current_Account

2

Personal_Current_Account

Credit_Card

Premium_Current_Account

3

Locker

Residential_Mortgage

Insurance

Credit_Card

Currency_Services

4

Personal_Current_Account

Trading_Account...