Data Sources

1. yahoo finance
http://finance.yahoo.com/q/hp?s=NWL&a=06&b=19&c=1984&d=08&e=24&f=2010&g=m

2. How to automate import of historical stock data from Yahoo Finance site into Access

http://www.experts-exchange.com/Database/MS_Access/Q_26499199.html

http://www.kdnuggets.com/datasets/index.html

3. Canada Open Dataset

http://data.gc.ca/eng

http://aws.amazon.com/cn/publicdatasets/
http://blog.visual.ly/data-sources/

SAS Road Map - SAS, BI , Excel VBA

1.
http://www.signetsoft.com/business-analytics-signet.html

Format numbers
Functions
Lookups
Conditional formatting
Data Validation
Sort and filter
Charts
Pivot Tables and Charts
Tabs: Home, Insert, Formula, Data, Review and View tab
What IF Analysis

Introduction to VBA
Introduction to macro recording, IDE
How VBA works?
VB Editor
Excel object model
Excel macro recorder
Programming concepts
VBA Language elements
Range Objects
Bug extermination techniques
Programming concepts
VBA Language elements
Range Objects
Bug extermination techniques
Communicating with your users
Simple dialog boxes
User form basics
User form controls
User form techniques and tricks
Accessing macros through UI
Creating Work sheet functions
Creating excel add-ins

VBA Resource

1. Visual Basic for Applications (VBA) macroshttp://msdn.microsoft.com/en-us/office/ff688774.aspx

Hash table - Data Step Hash Objects as Programming Tools

1. Data Step Hash Objects as Programming Tools
http://www2.sas.com/proceedings/sugi30/236-30.pdf

Resume Builder

1. effective code:
SAS® Macro Dynamics - From Simple Basics to Powerful Invocations
http://www2.sas.com/proceedings/sugi31/039-31.pdf