Select Page

Building Web Apps with SAS

Surprisingly little attention is given to the (huge) potential of the SAS platform for building web apps.  On the assumption this is due to sheer ignorance, the aim of this post is to share some of my experience, and give budding SAS web-developers a kick start in the...

Running EG or other client tools as SASSRV

Occasionally when debugging it can be useful to run as a system account for checking permissions etc. A useful utility for this (in windows) is the “runas” command.  For instance (from the command window): runas /user:”YourDomainsassrv”...

DIRECT_EXE warning

This one had me puzzled for a bit (SAS 9.2, Windows 2008, SQLNCLI10.1, OLEDB): WARNING: The current setting of the DIRECT_EXE libname option will not allow this SQL statement to be passed directly to the DBMS for processing. Explicitly setting the DIRECT_EXE...

Event Logging of Stored Process Server Sessions

Having seemingly brought down our 9.2 Windows 2008 STP server (only in DEV!!) during development of a yet another (awesome) STP web app, it occurred to me that more information was needed about just how many requests were being batted over.  Stored Process Error...

Get Physical Path From Metadata Libref

So it turns out that it is not possible to place a SAS lock on a table referenced via the Metadata Libname Engine: WARNING: LOCK is not supported in MLE. To circumvent this issue, one approach is to assign a libref directly. The following macro takes a libref (placed...