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