Tag: SAS

A New Look

If you’re a regular visitor to the NOTE: web site you’ll instantly notice that it looks different. NOTE:’s 2nd birthday is approaching (in July) so we thought it was time for a make-over. We’re pleased with the new, brighter appearance. Pleas…

Software Practice Advancement (BCS SPA)

I recently started a new contract in London. Having been based outside of London for the last couple of years, I’m being reminded of the benefits of working in the metropolis. One benefit is that I get to use public transport, thereby increasing my rea…

SAS Hits the Big Time

Recently, my mother handed me a copy of the May 2011 issue of Reader’s Digest magazine.  Now, Reader’s Digest is not a magazine that I ordinarily read (though I confess to being a fan of its monthly Word Power vocabulary quiz), but this particular issue holds special interest.  The article, Best of America, says that […]

Global Airport Database Conversion Code

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$ […]

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 […]

NOTE: Inadequate Mends

%macro article;
In the last couple of weeks I’ve been confronted with a lot of macro code. I love SAS Macro language (is there a cure for this?) but it drives me nuts when the name of the macro is not appended to the respective %MEND statement.

CDISC Express: A Glance

This weekend I tested an application that can automatically transform clinical data to CDISC SDTM compliant datasets(3.1.1 and 3.1.2), CDISC Express of Clinovo. According to its license statements, you can download it for free and for personal use only.
The core of CDISC Express is an Excel configuration file called Mapping File which defines all the […]

Delete non-exact duplicates in SAS

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 can&#82…