This demonstrates an easy way to calculate the Net Promoter Score, a measure of customer loyalty, in SAS’s PROC TABULATE. I prefer to use PROC TABULATE because of its power for various summaries. In the example we repeated the Net … Continu...
Read more »
A 100% stacked bar chart is useful for comparing the relative frequencies of an m x n table where frequencies in m are very different. While this is easy to do in Excel, SAS requires an extra step, which you … Continue reading →
Read more »
In Natural Language Processing it can be helpful within a larger body of text to standardize written numbers to Arabic numerals. For example, we will change “I am forty-six years old” to “I am 46 years old,” so the age … C...
Read more »
You should check for error return codes in any SAS programs that run unattended in batch jobs, so you can handle the exception properly. For example, if the data are invalid, you don’t want to generate reports or insert bad data into a database. ...
Read more »
This code creates a decision tree model in R using party::ctree() and prepares the model for export it from R to SAS, so SAS can score new records without invoking R. I use this method for several reasons. First, it’s convenient for my workflow t...
Read more »
This SAS code programmatically downloads monthly economic indicators from FRED, and merges multiple time series into a single data set for convenient analysis. FRED (Federal Reserve Economic Data) is an excellent resource from the Federal Reserve Bank ...
Read more »
When deleting non-complete duplicates in SAS, in each duplicate set you may want to keep a particular record identified by a rule: it may be the oldest, newest, first, or last observation in each set. You need a identifier to be unique, but you canR...
Read more »
SAS has powerful features for reading data out of text files (such as CSV, TSV, datalines, and various other formats), but while reading text, you may find your data set is missing rows and the log has this non-intuitive error message (well, “not...
Read more »