Tag: PowerShell

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

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

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

Calling Windows PowerShell from SAS: a simple example

As I mentioned in my introductory post about Windows PowerShell, you can use PowerShell commands as a simple and concise method to collect data from your Windows systems; information that is ripe for analysis within SAS. In this example, I’ll show a technique for using a SAS program to call […]

Running Windows PowerShell Scripts

Windows PowerShell is one of my favorite tools to use for gathering information from my PC and network, and also for automating processes.  If you are familiar with UNIX shells (such as Korn shell or its variants), you will probably be very comfortable with Windows PowerShell.  Just like its UNIX […]