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...
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 –...
Importing flow: ERROR – An error occurred trying to connect the responsible parties for the imported objects.  Reason: Can’t find resource for bundle java.util.PropertyResourceBundle, key ResponsiblePartyHandler.InvalidSearchAttrib.txt

Importing flow: ERROR – An error occurred trying to connect the responsible parties for the imported objects. Reason: Can’t find resource for bundle java.util.PropertyResourceBundle, key ResponsiblePartyHandler.InvalidSearchAttrib.txt

If you are getting the following message when importing a package containing a FLOW: ERROR – An error occurred trying to connect the responsible parties for the imported objects.  Reason: Can’t find resource for bundle java.util.PropertyResourceBundle, key...