Tag: SAS

NOTE: When WORK is not WORK

When you code a one-level data set name, i.e. a data set name with no libname specified, you probably expect it to be read or written from/to the WORK library, but that might not be so. Read on…

Subject to the value of the USER= option, one-level da…

Calculate Net Promoter Score in PROC TABULATE

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…

Is There Any Better Way? Publishing Process For CDISC Standards

  1. The Pain I read from Lex Jansen (@LexJansen) that CDISC SDTM v1.3 and SDTMIG v3.1.3 were newly released. It’s pretty nice since CDISC SDTM was supposed to be released semiannually in the new publishing cycle. We can see the team put great efforts on this new version, but frankly speaking, this delivery (the […]

Getting Certified

As a (certified) SAS platform administrator I often get asked how best to prepare for the SAS Certified Platform Administrator 9 exam. I don’t have a magic formula other than study and experience. My standard response is to direct people to the b…

Sublime Text 2 for SAS Programmers: A Quick Note

I’m playing with a new text editor, Sublime Text 2, and it has much potentials to replace my current handy Notepad++ and VIM. A quick note for further exploration(will keep update): 1. SAS syntax highlighting Sublime Text 2 doesn’t support SAS syntax natively. I got a workaround so I didn’t need to write my own […]

SAS Beats R on July 2012 TIOBE Rankings

The TIOBE Community Programming Index ranks the popularity of programming languages, but from a programming language perspective rather than as analytical software (http://www.tiobe.com). It extracts measurements from blogs, entries in Wikipedia, books on Amazon, search engine results, etc. and combines them into a single index. … Continue reading

100% stacked bar chart in SAS’s SGPLOT

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 →