In a previous article, I described how to use Windows PowerShell to connect to a remote SAS Workspace, run a SAS program, and retrieve the results. In that example, the only results I retrieved were the SAS log and SAS listing (text) output, if any. When you run a SAS […]
Tag: PowerShell
Using Windows PowerShell to connect to a SAS Workspace server
This post is another in my series about creating apps with SAS Integration Technologies, a topic that I’m preparing for SAS Global Forum 2013. In this article, I’ll describe how to use Windows PowerShell to connect to a remote SAS Workspace, run a SAS program, and retrieve the results. This […]
Using Windows PowerShell to find registered tables and columns in SAS metadata
In a previous post, I described how to write a Windows PowerShell script to connect to a SAS Metadata Server. In this post, I’ll show an example of something useful that you can do after you’ve established that connection. Specifically, I’ll show how to “ask” the SAS Metadata Server about […]
Using Windows PowerShell to connect to a SAS Metadata Server
SAS Integration Technologies provides a flexible platform to create all types of apps, from simple utilities to full-blown applications. As part of the research for my SAS Global Forum 2013 paper (Create Your Own Client Apps Using SAS Integration Technologies), I’ve been trying to invent some useful examples that you […]
My favorite SAS tips and tools from 2012
Many of my blogging colleagues are taking this week to reflect on their top posts in 2012. Some are using the visitor statistics to rank the posts, but as Andy Ratcliffe points out, that gives short-shrift to the late-season articles. This year, I’m going to use this space to recap […]
Powershell: Up to v3.0
Just update Windows Powershell to version 3.0 and I do like this new GUI (Integrated Scripting Environment, ISE) with a console, a script window and a command list (Powershell is a true Windows shell; you may try to type 1+2 in the old CMD console!): I also used a free Powershell GUI product, PowerGUI with […]
Read a Microsoft date-time value into a SAS date-time value
A colleague was recently working with a web service that supplies some date-time values using the Microsoft Windows internal representation. He called the web service to retrieve those values (along with other data) from SAS, and he needed convert these values to SAS date-time values. The Microsoft definition for a […]
Using Windows PowerShell to view your SAS data dictionary
In a previous post I showed how you can use Windows PowerShell (with the SAS Local Data Provider) to create a SAS data set viewer. This approach doesn’t require that you have SAS installed, and allows you to read or export the records within a SAS data set file. In […]