Category: SAS

Super Important Tip on Upgrading from 4.2 to 4.2 Add-in to MS Office

When upgrading from an existing 4.2 client install of SAS Add-in to MS Office, you are not prompted to enable the Outlook portion of the Add-in. As SAS points out in the KB Post http://support.sas.com/kb/40/272.html, there is a ‘Switcher Utility’ avail…

Wufoo and REST API

Wufoo (http://www.wufoo.com/) is a great service for creating user forms and getting input. Build a form interactively, let people fill it out, and Wufoo collects the results. If you haven’t checked it out before, I highly recommend this great service….

Reading a table from a website into a SAS dataset

Many a times we may want to read a table from the webpages into our datasets. This may be a requirement especially when I would want to analyse the stock market shares and their corresponding trends over the past. This can be done in many ways dep…

Sunil’s Top 10 SAS Papers: Guest Blog by Sunil Gupta

I recently learned about an interesting resource for SAS users.  Sunil Gupta—a SAS Press author and consultant—maintains lists of his favorite SAS papers on various SAS-related topics.  You can peruse these lists on his page on SAScommunity.org. Here are some of Sunil’s Top 10s: Sunil’s Top 10 PROC FORMAT/Functions Papers Sunil’s Top 10 PROC COMPARE […]

Visualize decision tree by coding Proc Arboretum

Decision tree (tree-based partition or recursive portioning) dominates the top positions of recent data mining competitions. It is easy to realize and explain like logistic regression, but usually brings more powers (AUC). Not like SVM, neural network …

SAS Transport Files and .NET

Well, someone contacted me about the Data Management Utilities. they loved them (thank you) but wanted to know about reading SAS Transport Files. Well, after fiddling with the localProvider a bit and getting nowhere, I stumbled onto something cool: Dow…

Putting the squeeze on your SAS data sets

I’ve known several people who were raised during the Great Depression, and I’ve observed that they are very mindful of waste. My wife’s grandmother used to save plastic bags, twist ties, and relatively clean alumninum foil for potential reuse in …