This is a simple routine for a lot of reporting work. Many people tend to do it in Excel by dragging the range after entering the formula in the 1st cell. However, coding in VBA and SAS will usually do it in more prompt and safe way.
VBA
VBA’s u…
Custom SAS graphs = competitive advantage
SAS/GRAPH gives you the ability to customize your graphs (or even create totally new types of custom graphs) … and it is my firm belief that it gives you a competitive advantage by allowing you to “make sense” of your data in ways your competitors c…
Halifax SAS User Group Wrap-Up
Well, it’s taken me a week to sit down and recap the great SAS User Group meeting we had last Friday in Halifax… blame it on the travel, a crazy work week, or blame it on the boogie. I prefer the boogie, myself, but that’s just me.I was fortuna…
Overcoming obstacles in analytics
The analytics field is ever-changing, which can create many challenges for professionals — especially those with massive amounts of data. We reached out to our speakers and sponsors of Analytics 2012 to ask what are the obstacles they’re facing toda…
nnet2sas() supports centering and scaling
nnet2sas() version 1 introduced a way to export a nnet() model trained in R to Base SAS through metaprogramming, and now nnet2sas() version 2 introduces support for variable centering and scaling as implemented in caret::train(). See the link for versi…
Finite Mixture Model for Loss Given Default (LGD)
Loss Given Default (LGD) is a key business metric of risk in financial service. One unique feature of this metric is overdispersion and the other is multi-mode.
Finite mixture model is an effective way to accommodate both. Multi-mode refers to the …