Stackoverflow hits 10,000 SAS questions!

Stackoverflow hits 10,000 SAS questions!

If you have a question about SAS – one that fits the definition of a good question – stackoverflow (SO) is a fantastic place to ask!  There is an active community, that cares about giving the best answers to your programming questions, often within...

Find MIN / MAX of character variables in sql

It is perfectly valid to use min() as a summary function on character values in proc sql, eg as follows: proc sql; create table test as   select min(name) as minval   from sashelp.class; This is not so, however, when using in an inline context: proc sql; create table...

The Performance of Dosubl vs Call Execute

Both dosubl and call execute accept raw SAS code as input.  The difference between them is that call execute will take your code and add it to the stack (so, after your data step completes) whilst dosubl will execute your code immediately. Dosubl is a fantastic...
Launching SMC on Mac OS over SSH with X11

Launching SMC on Mac OS over SSH with X11

As an avid developer of SAS Stored Process Web Applications, the Macbook Pro is my development machine of choice.  Since building a macro to programmatically create STPs, I’ve had few reasons to launch a VM to use client tools – but today I actually...