Posts Tagged ‘ sas administration ’

Fencing in your SAS users with LOCKDOWN

February 21, 2014
By
Fencing in your SAS users with LOCKDOWN

SAS administrators now have another tool to keep SAS users from straying off their permitted path: the LOCKDOWN system option. The option was introduced in "stealth mode" for SAS 9.4. In SAS 9.4M1, it became a true, documented option. For the official guide to creating "locked-down servers", see the SAS
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

Using Windows PowerShell to find registered tables and columns in SAS metadata

February 25, 2013
By
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
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

Controlling access to custom tasks in SAS Enterprise Guide

January 7, 2013
By
Controlling access to custom tasks in SAS Enterprise Guide

I've bragged about how easy it is to install custom tasks for SAS Enterprise Guide. It's simple: you copy the .NET assembly (usually a single DLL file) into one of the designated folders in your SAS Enterprise Guide installation, and your task just shows up in the menu. Since I
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

Calling Windows PowerShell from SAS: a simple example

September 15, 2011
By
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
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

Running Windows PowerShell Scripts

September 12, 2011
By
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
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Five strategies to eliminate passwords from your SAS programs

November 23, 2010
By

Many people mistakenly assume that just because you want to use a SAS program to access a protected resource (such as a database table), you must include the credentials for the resource inside your program. Few things cause a database administra...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

Process Explorer: tools for the SAS admin on Windows

November 22, 2010
By

It was over two years ago that I shared the tip of using Process Explorer to look under the covers at which SAS processes were running on your Windows environment. Process Explorer recently received a refresh, and it's worth downloading the new v...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.