Select Page

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...

proc fcmp – file log put % bug

Having worked a lot with proc fcmp lately, I think it’s fair to say that the procedure should be ‘handled with care’ Here’s an example of one of these weird / wonderful bugs (LIN X64, 9.04.01M3P062415): proc fcmp outlib=work.funcs.pkg;...
SAS L is StiLL aLive

SAS L is StiLL aLive

If you’ve ever done any moderate googling on a SAS topic you’ve probably unearthed a thread on SAS-L, quite possibly from several decades ago.  You’d be forgiven for assuming that this simply something that “used to exist’ because –...