SAS for Financial Engineering : SAS for Financial Engineering Shivgan Joshi
Content : Content Introduction Importance 3 big ones 2 strategies Conclusion References
Introduction : Introduction Course for SAS base Advanced Making it relevant to FRM (financial risk management)
Where it becomes important : Where it becomes important Handling large data Credit Risk Models Powerful predictive modeling Data handling from SQL same as MATLAB Getting live data vs data from server same as MATLAB Market Analytics and credit card which is not relevant to you Adds something to your resume
When it becomes distraction : When it becomes distraction Analytical people do it all the time CS people are proficient and this is not my job A subject of MIS Not to do too much with finance M Stat / M Tech CS people do this thing Rather focusing on Finance (FRM/CFA) would be a better ideas
The 3 big ones : The 3 big ones R vs SAS vs MATLAB Each of them have their own importance
SAS base prep : SAS base prep Strategy 1: Keep studying Strategy 2: Wait till you get money Strategy 3: Get local certification You can get it intensive for any time and give the exam. I would look into this just right now, although you don’t have the money
Start of with meaningful data : Start of with meaningful data Use financial data to explain base sas
Sharpness of Mind : Sharpness of Mind You sharpness of mind helps you to learn quickly these languages
Strategy : Strategy There are at least 200-500 commands you need to remember, and this will require a lot of memory Make around 50 programs and upload them
SAS Tricky things : SAS Tricky things Data Steps: Input gives the variables Cards or Datalines are same to input raw data from the sas program Picking data from other file Use of : and & for input data functionalities Ref: An Introduction to the SAS System Phil Spector, Statistical Computing Facility, Department of Statistics,University of California, Berkeley
PowerPoint Presentation : Data statement Get data in: Input/Inline/Set/Merge Modifying creating new variables If then else statements Arrays (same concept in MATLAB etc) SET mylib.internationaltours A Hands-On Introduction to SAS® DATA Step Programming by Debbie Buck, et. al.
Interesting areas : Interesting areas Introduction to DATA Step Processing Temporary versus Permanent SAS Data Sets 25
SET the trouble maker : SET the trouble maker Temporary and Permanent data sets
Data in a SAS Data Set : Data in a SAS Data Set Infile SET statement MERGE statement MODIFY statement UPDATE statement
Printing Data : Printing Data Using Options in printing data Proc print From: base step 1001
Missing Value based questions : Missing Value based questions
SAS Finance basic application : SAS Finance basic application Data Preparation for Analytics Using SAS makes it clear what is happening MATLAB Data Cleaning for time series analysis Volatility computations for interest rate games
Base exam contents : Base exam contents Data Step Proc step
Logistic Regression : Logistic Regression More used than any other thing
Trouble giving commands : Trouble giving commands @ symbol Dot gives a lot of confusion SET statement is also not easy to understand where it creates temporary data Permanent vs temporary data sets using librefer Difference between library, data sets, array
Test multiple conditions with IN, OR, or AND operators : Test multiple conditions with IN, OR, or AND operators
Macro : Macro The names of macro variables start with an ampersand (&), while the names of macros start with a percent sign (%)
Financial time series : Financial time series Books on SAS for FTS It is the most important application of SAS in the world Beside this it is VAR and Besal 3 implementations
SAS Certified Statistical Business Analyst : SAS Certified Statistical Business Analyst SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling Credential ANOVA, Linear Multiple regression Logistic Regression Prepare Inputs for Predictive Model Performance Measure Model Performance
Doubt in Code : Doubt in Code options pagesize=60 linesize=80 pageno=1 nodate; libname mylib ’ permanent-data-library’; data mylib.populartours; infile ’ input-file’; (why we have used infile when we have imported the data using mylib command) input Country $ 1-11 Nights AirCost LandCost Vendor $; run; proc print data=mylib.populartours; title ’Data Set MYLIB.POPULARTOURS’; run;
Practicing and making use of your own bond data : Practicing and making use of your own bond data Use real data when you practice SAS
Best Book : Best Book Step-by-Step Programming with Base SAS® Software by SAS Publication
SAS Predictive modeling Prep Theory : SAS Predictive modeling Prep Theory Accessing and Assaying Prepared Data Introduction to Decision Trees Regressions (Anova, Logistic regression) Neural Networks and Other Modeling Tools Model Assessment & Implementation Pattern Discovery
SAS predictive Modeling : SAS predictive Modeling Data Preparation Missing values Initial data exploration including data visualization/measurement levels or scales/variable reduction Transformation/recoding/binning Predictive Models Data splitting/balancing/overfitting/oversampling Variable importance/odds ratio Profit/loss/prior probabilities Model Assessment Comparison between models/lift chart/ROC/profit & loss Assessment of a single model Scoring and Implementation
Conclusion : Conclusion
References : References SAS Base exams book The Little SAS Book: A Primer Base SAS Programming Black Book (paperback) Step-by-Step Programming with Base SAS® Software