Accurately Calculate AUC (Area Under the Curve) in SAS for a binary classifier rank ordered data
In order to calculate AUC for a given SAS data set that is already rank ordered by a binary classifier (such as linear logistic regression), where we h…
SAS DIF function – Comparing previous records
The SAS DIF function is another useful tool for operating on previous records. Lets say you want to know the difference in the last year’s revenue and this year’s revenue. Here is the data: Year Revenue 2001 10,000 2002 30,000 2003 60,000 2004 100,000 data revenue1; set revenue; Rev_increase=dif1(revenue); run; Year Revenue Rev_increase 2001 10,000 […]
The man behind the curtain: SAS Deployment Wizard
More questions answered:
Q: I’m looking for a simple install guide for 9.2
A: I couldn’t answer the question about why SAS 9.2 has different installation documentation, so I enlisted the help of Fred Perry who is a major contributor of content to …
Answering the questions from the feedback forms
We have recently added feedback forms and short surveys on some pages on support.sas.com. We don’t ask for your e-mail address or require you to log in to the site. That means that all of the comments are anonymous. We think the ease of commenti…
Tweak PROC FASTCLUS for 1-Nearest Neighbor / Closest Match
In most table lookup tasks, we are doing EXACT matching. However, sometimes we are looking for closest match in the lookup table. By ‘closest’, we mean smallest Eucleadian distance:
||X-Y||2
Typically we have to manually code the search function …
SAS: “The query requires remerging summary statistics back with the original data”
Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sq…