enterprise guide

5月 202014
Giovanni Monopoli is the Strategic Analysis and Financial Planning Manager within the Finance Department at QVC Italy. Next month, he’ll be presenting at the Analytics 2014 conference in Frankfurt, Germany about how the broadcast channel uses analytics – specifically SAS Forecast Studio. With live broadcasts 17 hours a day, QVC […]
2月 072014

Today I tried to install a SAS format viewer, one of my favorite SAS AF utilities in a virtual machine, and it came out a bad news and a good news.

The bad news is that the website I used to download the SAS Format Viewer (by Frank Poppe) is no longer accessible(LESSON LEARNED: make an offline copy when you check piece of codes online!).

While the good news is, that  a company named BiX just released a free version of (yet another) SAS format viewer. I got it tested and it works pretty well, just like Poppe’s version I used.


I like to work with SAS Display Manager (DMS) in Windows where I can get code editor, log window, output window, data explorer, etc at a NOT-TOO-BAD GUI, and I can also implement some productive SAS AF utilities like format viewer and log checker.

SAS Enterprise Guide(EG) actually is a much modern IDE for SAS programmers and my favorite AF utilities can be also replaced by some handy EG add-ons. Currently I’m not fully engaged in it for my personal development work because

  • it consumes more resource than DMS and usually I can’t stand with it.
  • EG also doesn’t support all programming features supported by SAS Base, for example, it doesn’t recognize the clipboard behavior showed up in the following demos:


I believe EG will rule the world in the future, and even now, in many sites, it was chosen as the solo interface for SAS programmers.  I understand IT admins will benefit it a lot due to easy implantation, maintenance and control, but for SAS programmers, it’s better to have many options.

10月 052013

Now Appearing at Western Users of SAS Software 2013Here is another presentation to which I have contributed for the Western Users of SAS Software 2013 conference.

Your Resume–Selling Yourself Using SAS

I am honored to have served as a co-author with Rebecca Ottesen on this highly original paper.  This paper shows how to use your SAS skills to create a resume that is clever, unique, and effective.

Here is an excerpt:

Your resume should demonstrate strengths and skills, cite meaningful performance metrics, quantify contributions to the organization, and set you apart from the competition, all while being concise and staying to the point.  As a SAS user, it is likely that the skill set you would like to showcase involves programming and data analysis, so it seems perfectly natural that you should use these skills to create content for your resume.  A well thought out SAS graphic or table might be the perfect selling point to catch the attention of a hiring manager.

Here is an example of a graphic showing a timeline for work and academic experience:

Your Resume

If you are at the conference, I hope you will attend our presentation Wednesday November 13, 2013 2:30-2:50pm. If not, then you can download the paper here.

10月 032013

Now Appearing at Western Users of SAS Software 2013With the Western Users of SAS Software 2013 conference coming soon, I am looking forward to being part of three presentations.  One of those presentations is

Writing Code in SAS Enterprise Guide

This is based on a paper written several years ago for SAS Enterprise Guide 4.1.  That paper became obsolete almost immediately.  So I’ve been wanting to update it for quite some time.  This new paper applies to Enterprise Guide 4.2, 4.3, 5.1 and 6.1.

Here’s an excerpt:

Using SAS Enterprise Guide, you can manipulate data and run reports without ever writing a single line of SAS code.  So it’s not surprising that many SAS programmers believe that SAS Enterprise Guide is only useful to non-programmers.  If you love the SAS language, why would you ever want to use SAS Enterprise Guide?

It turns out that there are several reasons why you might want to do just that.  SAS Enterprise Guide offers programmers a variety of ways to run code.  You can type a program like you do in Display Manager, but you can also use the point-and-click features of SAS Enterprise Guide to generate programs  that you can then modify.  In addition, SAS Enterprise Guide organizes your work into projects making it easy to find your programs, logs, and results; and the process flow diagrams show at a glance how everything in your project fits together.

However, writing programs in SAS Enterprise Guide does require learning a new environment with new windows and a new system for organizing your work.  As with any new skill, there is a learning curve.  The goal of this paper is to ease that transition by explaining SAS Enterprise Guide from a programmer’s perspective.

If you are at the conference, I hope you will attend my presentation Wednesday November 13, 2013 3:30-4:20pm. If not, then you can download the paper here.

And if you can’t attend my presentation, you may want to watch this video about coding with SAS Enterprise Guide.

5月 142013

The Little SAS Book: A Primer, Fifth EditonOne of the problems that Lora Delwiche and I face as authors of two books with similar titles (The Little SAS Book and The Little SAS Book for Enterprise Guide) and multiple editions (five of LSB and three of LSBEG) is explaining how the books are different.

The two books are totally different–and complementary.

So I was delighted to see that someone at SAS Press has written a great summary comparing the various editions.

Did you know that the title The Little SAS Book was originally a joke? We explain that and give a little history on sasCommunity.org.