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 reproduced the table below, as a quick reference...

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 are missing the correct PORT. For guidance and best...

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 SAS/AF. This enabled point and click...

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 instruction. The issue? Malformed XML (of course). I’d forgotten to add the <Metadata> tags. The correct code block would...
Using CURL with SAS Stored Processes

Using CURL with SAS Stored Processes

I’ve said it before and I’ll say it again – SAS is an unparalleled platform for lightning fast development of enterprise-grade, business focused web applications.  Not least because it comes pre-installed with a Web Server and an incredibly powerful...
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...
The Sasensei Bitcoin Challenge

The Sasensei Bitcoin Challenge

To celebrate the recent launch of the Sasensei final level (Custom Quiz Builder) we’re running a promotion in April, May and June this year. The prize – $100 in Bitcoin – is given to the player who submits the best question of the month. Note that...