Cohort approach is a widely-used method in creating transition matrices for evaluation of credit risk. In the example below, I made a macro to automate this process. Although the code is for one-year period transition matrices, scorecards for multiple…
Category: SAS
Which logger did that SAS log message come from?
Occasionally you might want to generate a custom SAS log file, perhaps to be parsed and analysed to generate a custom report. You want to focus on a specific subset of messages and already know that you can modify the logging configuration file and attach the logger that generates the message to an appender to […]
A car mechanic is not necessarily the best car driver
Recently on the SAS Training & Certification LinkedIn Group, Crystal posted this question about wanting to become a SAS BI developer:
“I am a Certified SAS Professional that is interested in broadening my skill set and knowledge by moving i…
Behind the scenes: importing Excel files using SAS Enterprise Guide
I hope that the following statement is not too controversial…but here it goes: Microsoft Excel is not a database system.
That is, I know that people do use it as a database, but it’s not an application that supports the rigor and discipline of…
A macro calls random forest in SAS
SASHELP.CARS, with 428 observations and 15 variables, is a free dataset in SAS for me to exercise any classification methods. I always have the fantasy to predict which country a random car is manufactured by, such as US, Japan or Europe. After tryi…
A car mechanic is not necessarily the best car driver
Recently on the SAS Training & Certification LinkedIn Group, Crystal posted this question about wanting to become a SAS BI developer: “I am a Certified SAS Professional that is interested in broadening my skill set and knowledge by moving into th…
Do do do – another Aussie blogs the SAS
One of the most experienced SAS installer/architects I know has finally decided to add his wisdom to the blog space! Michael Dixon from Scorpio has decided to pen his experiences dealing with implementing SAS software in a myriad of customer environments over at : http://scorpiosoftware.blogspot.com/ Check it out when you get a chance! (ps. ignore […]
Making the results of the analysis accessible
We have all been there. You have just completed an analysis to be proud of. You cleverly collected data from many information sources. Then, through nifty data management that really shows your sas skills, you thickened the data mart with meaningful ag…