Susan Slaughter

Archive for May, 2010|Monthly archive page

Top 10 Reasons to Use SAS Enterprise Guide

In Enterprise Guide, Everything, Little SAS Book Series, SAS on May 25, 2010 at 10:22 am

There are many reasons to use Enterprise Guide. Here I present my list of the top 10. The drum roll, please….

10. It’s free

If you have a Base SAS license for the Windows operating system, then you don’t have to pay a cent more to use Enterprise Guide. So you might as well try it, right?

9. It never hurts to have another skill

With just a little bit of practice, you can master EG and add another item to your resume.

8. Learn to write SAS code

Well, sort of. EG is already a tool for learning SAS programming, but there is room for improvement. To fulfill its potential EG needs two things.

First, it needs to hide those ugly housekeeping statements that get tacked to the beginning and end of every SAS program when EG passes it to your SAS server. EG doesn’t need to get rid of them, just give us an option to hide them–and make hiding them the default.  EG 4.2 has taken a step in the right direction because the output now includes a tab that shows just the normal code, but the log is as confusing and unfriendly as ever so there is still room for improvement.

(I have just been informed by Chris Hemedinger of SAS Institute fame, that you can make most of the housekeeping statements disappear from your log by selecting Tools > Options > Results and unchecking Show generated wrapper code in SAS log. Sweet! Now if they would just make this the default so that newbies don’t have to figure this out, I would be completely satisfied.)

Second, EG needs a DATA step builder because the DATA step (what power, what elegance!) really is the secret to SAS’s success. There is good news on this. The next release of EG (4.3) lacks a task to build DATA steps, but it does include promising features that will help new programmers to write SAS programs (including DATA steps).

We may yet see EG transformed into a powerful learning tool for programmers.

7. Run SAS on a remote server

You can already do this, of course, with SAS/Connect, but it’s easier with EG. However, installing the software and setting up those servers is still not for the faint of heart. And you’ll need SAS Integration Technologies which, I understand, is pricey.

6. Generate reports in PDF and RTF output without writing ODS statements

Because not everyone wants to write ODS statements.

5. Learn to write SQL code

If you already know how to write SAS code, but you have yet to master PROC SQL, then you are in luck. You really can learn to write SQL code by using the point-and-click Query Builder and then studying the code it generates. You’ll be spouting terms like left inner join, right outer join, and full join in no time.

4. PROC TABULATE with ease

Personally, I’ve never considered PROC TABULATE that hard to use. But I will admit that you have to take it slowly, testing after you add each individual statement, option, or variable. But with EG it’s as easy as can be. Just point-and-click your way to the rectangular, summary report of your dreams complete with the colors, fonts, and formats of your choice.

3. Love that Style Manager

Because hardly anyone wants to write TEMPLATE procedures.

2. Process Flows

See–at a glance–the logic behind your work, how it all fits together, how it builds to your final results.

1. Projects

Keep all your tools in one box (where you can find them!) instead of spread out all over the garage. Stop asking yourself, “Now where did I put that SAS program/output/data set?”

The Little SAS Book for Enterprise Guide 4.2: The Authors’ Cut

In Enterprise Guide, Everything, Little SAS Book Series, Quotations, SAS on May 12, 2010 at 12:40 pm

From the first edition, The Little SAS Book: A Primer has had quotes at the beginning of each chapter. It is a literary, whimsical touch, intended as much for irony as for inspiration.

But when we wrote the first Little SAS Book for Enterprise Guide, we had such a tight deadline that we didn’t have time to find quotes.  This time around, however, we made adding quotes a priority. And I’m proud to say that we found some really good ones–18 good ones, in fact, enough for every chapter and tutorial, and even for the acknowledgments and appendix.  However, we also found some great quotes that weren’t quite right for the book. So here I present, for your edification and enjoyment, the quotes that ended up on the cutting room floor:

The author who speaks about his own books is almost as bad as a mother who talks about her own children.
Benjamin Disraeli, speech Nov. 19,1870.

Let him be kept from paper, pen, and ink;
So he may cease to write, and learn to think.

Prior, To the Person Who Wrote Ill, On Same Person.

Words, words, mere words, no matter from the heart.
Shakespeare, Troilus and Cressida. Act V. Sc. 3. L. 108.

Syllables govern the world.
John Selden, Table Talk, Power.

It is much easier to be critical than to be correct.
Benjamin Disraeli (Earl of Beaconsfield), Speech in House of Commons, Jan. 24, 1860.

The art of quotation requires more delicacy in the practice than those conceive who can see nothing more in a quotation than an extract.
Isaac Disraeli.

Every quotation contributes something to the stability or enlargement of the language.
Samuel Johnson, Preface to Dictionary.1

Bring me no more reports.
Shakespeare, Macbeth, Act 5, Sc. 3, L. 1.

Next to the originator of a good sentence is the first quoter of it.
Emerson, Letters and Social Aims, Quotation and Originality.

With just enough learning to misquote.
Byron, English Bards and Scotch Reviewers L. 66.1

The greater part of our writers…have become so original, that no one cares to imitate them: and those who never quote in return are seldom quoted.
Isaac Disraeli, Curiosities of Literature, Quotation.

Fine words! I wonder where you stole them.
Swift, Verses. Occasioned by Whitehed’s Motto on his Coach.

I always have a quotation for everything—it saves original thinking.
Lord Peter Wimsey in Have His Carcass by Dorothy Sayers, 1932.