SAS Performance Tuning - Configuration and Tuning Guidelines for SAS® 9 in Microsoft Windows Server 2008

Configuration and Tuning Guidelines for SAS® 9 in Microsoft Windows Server 2008
http://support.sas.com/resources/papers/WindowsServer2008ConfigurationandTuning.pdf

SAS Design Pattern

1. SAS® Macro Design Patterns
http://www2.sas.com/proceedings/sugi31/173-31.pdf

2. Toward Object-Oriented Macros in SAS
http://analytics.ncsu.edu/sesug/2004/TU11-Tabladillo.pdf

3. Methodical SAS Programing
http://www.sascommunity.org/seugi/SEUGI1994/Methodical%20SAS%20Programming.pdf

4. Creating Data Driven Programs with the Macro Languag
http://www2.sas.com/proceedings/sugi24/Posters/p254-24.pdf

5. Building Data-Driven Applications Using the SAS' Applications System: Selected Techniques
http://www.sascommunity.org/sugi/SUGI92/Sugi-92-42%20Henderson%20Johnson%20Rabb%20Septoff%20Shusterman%20Smith%20Thornton%20VanDusen%20Yuan.pdf

6. A Modern Software Design Principle Applied To SAS Macro Programming: The Inversion Of Control Concept
http://www.phusewiki.org/docs/2011%20Papers/AD10%20paper.pdf

7. I Object: SAS® Does Objects with DS2
http://www.pharmasug.org/proceedings/2014/BB/PharmaSUG-2014-BB05.pdf

8. Table-Driven Strategies for Rapid SAS Applications Development
http://www.yieldwise.com/syllabuses.pdf

9. DS2: The New and Improved DATA Step in SAS
http://www.mwsug.org/proceedings/2014/BB/MWSUG-2014-BB10.pdf

10. Parallel Data Preparation with the DS2 Programming Language
http://www.wuss.org/proceedings14/109_Final_Paper_PDF.pdf

SAS DS2 --- Data Step 2

Main Features include
  Key Features : Methods, DATA program, Package, and Thread

• define vars,
• define dataset. 
• hash table, 
• init-run-term, define methods, 
• overload, 
• multi-threads, 
• define package, 
• use SqlStmt, 

Reference:
Using Base SAS® to Extend the SAS® System
http://support.sas.com/resources/papers/proceedings14/SAS013-2014.pdf


Parallel Data Preparation with the DS2 Programming Language
http://support.sas.com/resources/papers/proceedings14/SAS329-2014.pdf

The New SAS® Programming Language: DS2
http://support.sas.com/resources/papers/proceedings12/397-2012.pdf

I Object: SAS® Does Objects with DS2
http://support.sas.com/resources/papers/proceedings14/1283-2014.pdf

A Paradigm Shift: Complex Data Manipulations with DS2 and In-Memory Data Structures
http://support.sas.com/resources/papers/proceedings14/1797-2014.pdf

Run SAS from VBA with full access

http://stackoverflow.com/questions/17732725/run-sas-from-vba-with-full-access

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