I love the SAS macro language and the power it gives you. Being able to control the creation of a SAS program, or its execution path, is immensely valuable. The SAS macro language contains the vast majority of the functional and logic capabilities of t…
Tag: macro
NOTE: There’s No In In Macro (or is there?!)
I love the SAS macro language and the power it gives you. Being able to control the creation of a SAS program, or its execution path, is immensely valuable. The SAS macro language contains the vast majority of the functional and logic capabilities of t…
Scheduling Jobs
We’ve been on overload the last week with urgent requests as the big yearly meeting looms in the not so distant future. Unfortunately, this means that every single employee is frantically pulling data and hammering the db2 server with requests. I’ve been working around the noticeable slowness by either shortening my date ranges but I […]
Automate univariate volatility modeling by macros
GARCH (generalized autoregressive conditional heteroscedasticity) models are widely used in market risk industry to estimate and forecast the volatility of returns. GARCH, including many variants like A-GARCH, GJR-GARCH and E-GARCH, is especially suit…
Using Proc IML for credit risk validation
Validation step is crucial for a scorecard in credit risk industry. Gunter and Peter mentioned in their fantastic book [Ref. 1] that cumulative accuracy profile (CAP) and receiver operating characteristic (ROC) are two popular methods. Thus, the value…
A scorecard for default risk with sparkline
In the 1st chapter of their must-read credit risk modeling book, Gunter and Peter used the ratios of working capital(WC), retained earnings(RE), earnings before interest and taxes(EBIT), sales(S) and market value of equity(ME) over either total liab…
NOTE: Parameter Validation – %DATATYP
In yesterday’s article on coupling, I showed how the use of macro parameters can decouple your macros, making them more maintainable and reliable. Building-in some parameter validation is always a good practice too. Some simple, basic validation can so…
NOTE: Coupling, Bad
In my recent article on %MEND I said I didn’t like nested macro definitions. Some of my correspondents have suggested it’s a good means of keeping macro code near to where it’s called. I think this suggests a bad approach; namely, the i…