Finding MIN (or even MAX) of character variables in SQL

It is perfectly valid to use min() as a summary function on character values in

Building SAS Apps Locally

I’ve recently been using Visual Studio to build my SAS Web Apps, which is great as the intellisense will even scan css files to help with code completion.  Perhaps the best feature though is the ability to right click and immediately ‘view in browser...

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 utility, with the following error returned: The export process has failed.  The native implementation module for the security package could not be found in the pa...

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: ERROR: Invalid use of sign notation. Curious, I extracted the code and ...

SAS/Share ERROR: Invalid object specifi...

Had an interesting error message today (SAS 9.3, Windows 2012R2), which appeared to be truncated: ERROR: Attempt to connect to server "dev01.domain.com".__8551 rejected by server. ERROR: Invalid object specifi... ERROR: Error in the LIBNAME statement...

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

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 extended-ascii) characters within SAS. There is a great SUGI paper about thi...

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 works fine for di...

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)Directly by calling sas.exe (presuming you are running on a box with a local install)Indirectly via the SAS St...

Chaining Windows Commands in SAS Filename Pipe (&)

Using filename pipe (instead of the X command, or call execute) is a great way to submit OS commands, not least because the standard output can be read directly into SAS.But how does one submit multiple commands in the same filename (or file) stateme...
« Older EntriesNext Entries »