Using Windows PowerShell to download a file from a SAS Workspace session

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 […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

Doing more with SAS Enterprise Guide automation

Have you ever selected File->Schedule Project or Schedule->Process Flow in SAS Enterprise Guide? Are you curious about what magic these actions will trigger? Here's what happens: SAS Enterprise Guide creates a VBScript program that contains the instructions to start SAS Enterprise Guide, load your project, run your project or flow, […]

Post a Comment

Build your own SAS data set viewer using PowerShell

In about 30 lines of PowerShell script, we can build a SAS data set viewer that: Does not require SAS on the PC Provides very basic filtering capability Also allows for easy export to CSV All you need is the ability to run PowerShell scripts, and the SAS Local Data […]

Post a Comment

Using Windows PowerShell to report on your SAS Enterprise Guide project files

This blog post is a "mashup" of a couple of my previous posts, combining the lessons to create something brand new that I hope you will find useful.  First, let's review what we know: SAS Enterprise Guide supports a scriptable object model, which allows you to write scripts or programs […]

Post a Comment