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

Modernising Legacy SAS SCL / AF Applications

Before SAS Studio, and even EG (but after display manager), there was a desktop application used exclusively for accessing SAS. It was known as Base SAS, and within it there was an application development facility known as S...

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

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

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

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

« Older Entries