The Global Airport Database (GAD) lists the longitude / latitude in sexagesimal notation which makes it a pain to plot on any sort of map using a coordinate system. The following SAS code will convert the GAD and should result in file similar to airports.csv. data airports; infile ‘AirportDatabase.txt’ dsd dlm=’:’; input icao$ iata$ name$ […]
A scorecard to create transition matrices by cohort approach
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…
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…