Dictionary of Dictionaries

The SQL procedure contains a lot of metadata information in the special DICTIONARY libref, and I often find myself needing to call select * from dictionary.dictionaries in order to query it. So to save time I've...

Cannot POST /SASStoredProcess/do/

You might see Cannot POST /SASStoredProcess/do/ when building a SAS Web App on SAS 9. The reason you see this, is that you have an incorrectly defined URL - either the host / server name is incorrect, or you a...

ERROR: Expected a comment or processing instruction.

Whilst creating a new macro for the macrocore library (mm_adduser2group) I received in my log: ERROR: Expected a comment or processing instructi...

ERROR: The request ? is missing required parameter Function Name.

I had this head scratcher today, when submitting some XML to SAS via proc metadata:

ERROR: The request ? is missing required parameter Function Name.

Turns out this was a simple fix - the input fileref simply wasn’t ...

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

Find MIN / MAX of character variables in sql

It is perfectly valid to use min() as a summary function on character values in

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

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 - up until recen...

Importing flow: ERROR - An error occurred trying to connect the responsible parties for the imported objects.

If you are getting the following message when importing a package containing a FLOW:

SAS As A Service - an easy way to get SAS into Excel, Power BI

When we think about using SAS with Excel, one begins to groan at the myriad of options - DDE, SAS Addin, various Excel-ish library engines, IOM in VBA, etc etc etc.

What if there were a simple technique, quick to set up, and easy to adjust?...

« Older Entries