%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.
…
Jedi SAS Tricks: Macro Q functions
James Bond: “Give me the old fashioned target range, Quartermaster. “ Q: “Yes, well, it’s called the future, so get used to it.” In James Bond movies, it’s Q’s job to disguise wickedly effective technology as seemingly innocuous everyday object…
Jedi SAS Tricks: Macro Q functions
James Bond: “Give me the old fashioned target range, Quartermaster. “
Q: “Yes, well, it’s called the future, so get used to it.”
In James Bond movies, it’s Q’s job to disguise wickedly effective technology as seemingly innocuous everyday …
Example 8.38: WriteXLS to create spreadsheets
In our last entry, we described reading Excel files. In this entry, we do the opposite: write native Excel files.RIn R, the WriteXLS package provides this functionality. It uses perl to do the heavy lifting, and the main complication is to install th…
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 […]
Macros communicate SQLite and SAS without ODBC
SQLite is an open-sourced relationship database management system with full functionality [Ref.1]. The light-weight (300k+ size) and zero configuration features distinguish it from its’ 800-pound counterparts like Oracle or MySQL. Thanks to the rise…