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-developer...
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. This one had me puzzled for a bit (SAS 9.2, Windows 2008, SQLNCLI10.1, OLEDB): 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. So it turns out that it is not possible to place a SAS lock on a table referenced via the Metadata Libname Engine: Make your metadata queries more versatile by checking for multiple conditions in a single pass! When using the OR condition, remember to prefix subequent attributes with the @ symbol. See below for testing whether a Stored Process user is in a c... In building a script to read in the LSF log files (lsb.events files), it was apparent that the file structure has changed across LSF versions. What is not so apparent is where the documentation resides.. So here’s a quick ref guide.
A useful utility for this (in windows) is the “runas” command. For instance (from the command window):DIRECT_EXE warning
Event Logging of Stored Process Server Sessions
Get Physical Path From Metadata Libref
WARNING: LOCK is not supported in MLE.
To c...Use OR condition in metadata OMSOBJ query
Platform Computing - LSF documentation
...
