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 ...
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;
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..Error trying to establish connection: Unable to Initialize: Invalid authorization specification
