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:

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

Converting SAS date to Javascript datetime (in Javascript)

Converting a SAS date or datetime to javascript isn’t hard, but still - it should be easy to google for!

  var dtSAS=20563;

Error trying to establish connection: Unable to Initialize: Invalid authorization specification

Thought I’d write this one up as the exact error message didn’t appear on google.  Of course, the sharp eyed among you will quickly spot the missing security / authorisation info..

Next Entries »