The native implementation module for the security package could not be found in the path.
Noticed today that our UAT 9.3 environment was failing to execute the SAS ExportPackage
proc metalib - ERROR: Invalid use of sign notation
So today I dropped a column in a SQL Server table (using SSMS) and duly checked out the SAS metadata in DI Studio in order to ‘Update Metadata’.
It failed with a strange message:
SAS/Share ERROR: Invalid object specifi...
Had an interesting error message today (SAS 9.3, Windows 2012R2), which appeared to be truncated:
Adding SAS Configuration Manager plugin to SMC
The SAS Configuration Manager plug-in is great for tweaking settings of the SAS Web Applications without poking around in xml and config files. However, you may find it missing from the usual place under the Application Management folder in SAS M...
Stripping Non-ASCII Characters within Macro
Hit once more with a pesky en-dash issue (likely related to the transcoding between SAS & SQL Server) I discovered today there was no ‘in-built’ way to remove non-ascii (or extende...
Reading UTF-8 in Filename Pipe
Having been blessed with an en-dash (alt + 2013) in our TFS project root, I’ve been having lots of fun getting SAS to ‘play nicely’ with non-ascii characters when running OS commands (eg tf.exe).
Storing the values in macro variables wo...
Invoking Stored Processes with Powershell - the easy way
There are a number of ways to run SAS from Powershell:
- Using SAS Integration Technologies (Chris Hemedinger has some great resources on this)
Chaining Windows Commands in SAS Filename Pipe (&)
Using filename pipe (instead of the X command, or
Visual Studio Build Controller does not contain an enabled build agent with name * and no tags.
Currently working on putting our SAS deployment process into TFS and Release Management - part of which involves creating a ‘build’ in Visual Studio.
The below caused a build failure, and didn’t come up in google:
Extracting Active Directory accounts into SAS using Powershell
Having a list of domain users and associated properties can be useful for a number of reasons:
- Identifying joiners / leavers
- Getting a list of employees
- Converting usernames into email addresses
- Alerting ...
