The SAS Dummy

Using the X and SYSTASK commands from SAS Enterprise Guide

nospam@example.com (Chris Hemedinger) — Thu, 19 Nov 2009 14:23:00 -0500

If you're accustomed to using "shell" commands from within your SAS programs (using the X command or SYSTASK statement, for example), you'll find that those statements won't work when you run your program from within SAS Enterprise Guide. When you try them, you will probably see one of the following error messages:

ERROR: Shell escape is not valid in this SAS session.
ERROR: Insufficient authorization to access SYSTASK COMMAND.

Out of the box, when SAS is configured for use by a client application like SAS Enterprise Guide, the shell command access is disabled through use of the -NOXCMD system option. Why? Well, in a distributed computing environment, your system administrators probably do not want SAS Enterprise Guide users to have full access to the shell environment on the host server.

If your SAS workspace is on a central server, you have just a couple of options:

Use a custom task to run system commands on your local Windows machine, if that's what you need to do.
Petition your system administrator to specify -ALLOWXCMD on the central workspace server. Good luck!

This same configuration applies even when using SAS Enterprise Guide with the SAS that's installed on your very own desktop. You might argue, "But it's my desktop machine! I should be able to run commands on my own machine." To which I would reply, "You're right!".

You can change the registered SAS command that SAS Enterprise Guide uses in order to remove the -NOXCMD startup option. But since this involves unseemly interaction with the Windows registry, you might prefer to use a tool that does this for you. I've placed such a tool here. (It's a ZIP file that contains a program and a ReadMe.txt file with instructions.)

This tool displays the currently registered SAS command and allows you to change it. In addition to allowing you to modify the SAS command startup options, you can use the tool to help synchronize the registered SAS command on a 64-bit Windows platform so that it can be used by a 32-bit process (such as SAS Enterprise Guide).

Learn about ODS Statistical Graphics

nospam@example.com (Chris Hemedinger) — Fri, 06 Nov 2009 08:01:51 -0500

If you've read this blog before, then you already know about the ODS statistical graphics that are available in SAS 9.2. We've been talking about this innovation at SAS for years.

Now it's time to spread the news. Do your colleagues a favor: forward this post to them, or at least the link to this recorded web talk by Bob Rodriguez. It's free, it's informative, and it could change the way you use SAS.

Hooo-ray for Hollywood

nospam@example.com (Chris Hemedinger) — Tue, 03 Nov 2009 14:51:46 -0500

I've just returned from the Los Angeles Basin SAS Users Group (LABSUG), where I both presented a talk and learned from others. (The meeting was in Pasadena, but I did get a chance to tour the area, as you can see from my picture.)

The title of my talk was "Upping your SAS Game with SAS 9.2 and SAS Enterprise Guide". Here's the description:

Join me on a journey of how I use new and recent features in SAS to solve problems that are of high interest in today's Web 2.0 world. Specifically, I'll show how I've used SAS to analyze my history with a certain online movie rental service, and also how I can use SAS to keep tabs on my Facebook friends. We'll see how all of this can be put together within SAS Enterprise Guide, mixing out-of-the-box tasks with SAS programming techniques to create repeatable processes. We'll also save some time at the end for sneak peak at what's coming in the next release of SAS Enterprise Guide – SAS programmers will not want to miss this!

The main message of my presentation is this: there is a boatload of new features/functions/procs in SAS 9.2, and even in SAS 9.1.3, that are worth looking at and trying out. You can use these features to get real work done and modernize your SAS programs to take advantage of the latest stuff. SAS Enterprise Guide helps you along because it "puts you on the path" to the new stuff (such as ODS Graphics) with some of the point-and-click interfaces, but even if you work exclusively in SAS programs, you should take the time to learn about some of the new syntax available to you.

I also provided a preview of our next release of SAS Enterprise Guide; there was considerable jaw-dropping and drooling going on. You'll see much more of this at SAS Global Forum 2010.

If you want to peek at the slides from my LA presentation, here they are.

Where to find ODS Statistical Graphics in SAS Enterprise Guide

nospam@example.com (Chris Hemedinger) — Fri, 23 Oct 2009 12:56:05 -0400

Yesterday I attended a virtual talk by Bob Rodriguez on his famous topic: ODS Statistical Graphics in SAS 9.2. You can learn lots of details by reading his paper. Bob's paper shows examples of the graphs you can get, how to control their appearance, and what SAS syntax to use.

The question came up: can I access these great new statistical graphs in SAS Enterprise Guide? The answer is: Yes, of course. In fact, you'll get the new graphs automatically from most of the analytical tasks within SAS Enterprise Guide and SAS Add-In for Microsoft Office. No programming necessary!

Here are the tasks that currently provide the new graphs:

Cluster Analysis	One-Way ANOVA
Correlations	Principal Components
Distribution Analysis	Proportional Hazards
Factor Analysis	t Test
Generalize Linear Models	Create Time Series Data
Life Tables	One-Way Frequencies
Linear Models	Summary Statistics
Linear Regression	Characterize Data
Logistic Regression	Forecast Studio tasks (using SAS Forecast Server)
Mixed Models	Capability (Histogram, etc.)

Of course, you can also use SAS Enterprise Guide to run your own SAS programs and access any of the new ODS Graphics, using the approach presented in Bob's paper.

Welcome sasCommunity visitors!

nospam@example.com (Chris Hemedinger) — Wed, 21 Oct 2009 08:14:31 -0400

I arrived at work this AM to see a link to this blog featured as part of the sasCommunity.org Tip of the Day.

If you clicked on that link and landed here, welcome! I hope it was worth the click. Please, make yourself at home and browse through the 2 years (wow!) worth of blog posts that I've collected here so far.

Do me a favor: stop doing me favors

nospam@example.com (Chris Hemedinger) — Tue, 20 Oct 2009 12:45:35 -0400

A customer posted on the discussion forum that, much his dismay, SAS Enterprise Guide sets the NOFMTERR option automatically when connecting to a SAS session.

The FMTERR|NOFMTERR option specifies whether SAS should report an error when you attempt to reference a data column that has a SAS format applied, but the format definition cannot be found.

SAS Enterprise Guide has always set NOFMTERR, even though it's not the default setting for the option in SAS. Why? Because if you attempt to open data that references a SAS format that SAS cannot find, not only will you be unable to open the data, but you'll get a pop-up message that says something like "Format VAL. cannot be found". Because many SAS Enterprise Guide users are new to SAS, and that message is confusing at best, we erred on the side of allowing you to open the data even without the format. This decision was made in the very early days of the product over 10 years ago, and we've had no suggestions to change it. Then again, we didn't really tell people we were doing it.

In SAS Enterprise Guide 4.2 we made it easier to see exactly what's happening when SAS initializes. No more secrets! Here are the steps:

Select View->Server List
In the Server list, expand the server you are connecting to (ex: "SASApp" or "Local")
Right-click on the server name and select Properties.
Click on the Software tab.
Click on View Initialization Log.

You'll see a SAS log window that contains the same startup log that you might know from running SAS interactively (including the NEWS= content, if any!).

I'll tell you right now: one other system option that SAS Enterprise Guide submits is VALIDVARNAME=ANY, which makes it much easier to import those spreadsheet files with funny column names.

If you want to override these options at startup, that's easy to do by providing your own initialization statements. Check out this sasCommunity.org tip for instructions.

You can use it for evil, too

nospam@example.com (Chris Hemedinger) — Fri, 16 Oct 2009 07:43:06 -0400

I found this excellent example of What Not To Do on graphjam.com.

I was inspired to see if I could recreate something similar in SAS. You see the result here. Yes, the PIE3D statement is ready to do your bidding. If that's what you really want.

The CIO perspective from MWSUG

nospam@example.com (Chris Hemedinger) — Tue, 13 Oct 2009 07:53:19 -0400

Along with hundreds of SAS users, Alison (of sas.com fame) is attending the MidWest SAS User Group meeting. She recently "live-blogged" the keynote presentation from Suzanne Gordon, our CIO.

Suzanne does us proud every time. Check out what she had to say to the MWSUG attendees about her start at SAS and her career since. Also, Alison has been live-blogging MWSUG sessions with other SAS community notables, including Jon Weisz and Kirk Paul Lafler.

SAS 9.2 and SAS Enterprise Guide 4.2 on Windows 7

nospam@example.com (Chris Hemedinger) — Thu, 01 Oct 2009 11:44:00 -0400

I'm finding that you people just love these posts about what new environments that SAS supports, so here's another one.

Even though Microsoft Windows 7 hasn't hit the store shelves yet, I want to get out in front of it and say, "Yes, it's possible to run SAS and SAS Enterprise Guide on it." Because I know you're going to ask.

But just because it's possible, that doesn't mean it's officially supported yet. Official support of SAS software on Windows 7 is an initiative planned for the first part of 2010. But in the meantime, I've done some testing on the production version of Windows 7 and documented the steps that I found will work to get the basics running. By "basics", I mean SAS Foundation (9.2) and SAS Enterprise Guide (4.2), and even configured deployments that include a SAS Metadata Server, workspace, and stored processes.

I wanted to document the steps for those on the bleeding edge, but I don't want to imply that this is official support from SAS just yet. I've placed all of the details on sasCommunity.org. Don't worry, the steps are not too crazy -- no magic spells or rare ingredients needed. Just a little bit of candy coating on the installation to make it go down a bit easier.

If it works for you or if you have feedback, I'd love to hear it. You can comment back here on the blog or use the Discussion tab on sasCommunity.org.

SAS 9.2 support for Windows Server 2008

nospam@example.com (Chris Hemedinger) — Wed, 30 Sep 2009 15:38:04 -0400

When I said the release was imminent, I wasn't kidding. It's now available.

With SAS 9.2 Maintenance 2 we now have support for Windows Server 2008 (in addition to what we already had for SAS 9.1.3).

This 9.2 Maintenance release also has various fixes and improvements not only to the SAS Foundation products, but also other products such as SAS Enterprise Guide 4.2 and SAS Add-In for Microsoft Office 4.2 (both now labeled 4.22 in Help->About, for those folks who are counting the internal numbers).

How do you get it? Follow the instructions on the maintenance page (under "Where do I go from here?"). (It's not like a hotfix download; it's more like a "refresh" of your SAS software order.)

Other SAS blogs of NOTE:

nospam@example.com (Chris Hemedinger) — Wed, 30 Sep 2009 08:45:08 -0400

Hello Knowledge Thirsters,

Today I discovered that the NOTE: newsletter (pronounced /note colon/) has migrated to the blogosphere. I'm pleased and humbled to admit I've already learned a few things by reading it.

This site and others like Angela's SAS BI blog, the "SAS Tips" site, and the cacophony of voices on sasCommunity.org all contribute to the growing number of excellent resources from real-world SAS users.

And of course, you can always count on me here to provide an insular SAS perspective. I'm happy to be one voice in the chorus.

SAS 9.1.3 on Windows Server 2008

nospam@example.com (Chris Hemedinger) — Fri, 25 Sep 2009 14:22:54 -0400

I get this question all of the time on the discussion forum and this blog, so I feel I should help to spread the news.

SAS now supports SAS 9.1.3 SP4 on Windows 2008 (32-bit edition). Here is the official statement.

Update 07Oct2009: I changed this to indicate that the official support policy is that the 32-bit version of Windows Server 2008 is supported, and not the 64-bit version of the OS. However, SAS 9.2 Maintenance 2 does support both 32- and 64-bit Windows 2008.

Support for SAS 9.2 will be delivered with the SAS 9.2 Maintenance 2 release, which is imminent*.

* "imminent" is a word which here means: Real Soon Now, or Just Weeks Away. Less than a month. Before my next birthday.

They love us in Japan

nospam@example.com (Chris Hemedinger) — Thu, 24 Sep 2009 13:46:10 -0400

At least, they will love us when they see that we've translated the SAS Enterprise Guide 4.2 tutorial into Japanese and put it on the SAS support site.

We've also got three flavors of Chinese (zh-TW, zh-CN, zh-HK) and Korean now available.

These new editions join the Italian, German, Spanish, and French versions that we posted out there earlier this year.

And if you prefer English, that version is still right here.

Nutty uses for SAS

nospam@example.com (Chris Hemedinger) — Tue, 15 Sep 2009 08:35:00 -0400

Almost daily, I hear reports of scientific studies in which the researchers have used SAS for the data analysis. Typically I don't dig into the details because, frankly, the studies are usually way over my head. But this one about the effect of nut storage, nut size, and nut soaking on nut sprouting caught my eye.

It made me want to check whether this customer pays in cash(ews).

Lookin' professional

nospam@example.com (Chris Hemedinger) — Mon, 14 Sep 2009 16:24:33 -0400

Thanks to the folks who support our web presence, this blog page has just received a facelift (but alas, the blogger has not). New colors, easier navigation with the breadcrumbs up top, and a new banner image that shows the SAS for Dummies cover (as if to say, "really, he's not a dummy -- it's a play on words because of the book, get it?" But we all know better.) Gone are the M&Ms and SASDUMMY license plate. But we know they're still around, even if you can't see them on the blog.

This blog page is now more consistent with the many other blogs that we host at blogs.sas.com. Consistency is good, right? It helps you know what to expect. Usually.