BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Enterprise Guide

SAS Enterprise Guide: Do You Know Its Top Three Unknown Benefits?

Submitted by on 2012-02-26 – 10:39 AM 9 Comments

Sunil Gupta, www.SASSavvy.com, joins us today with three tips for using SAS Enterprise Guide. He runs the SAS-Savvy website, which I reviewed in the Are You SAS Savvy post.  

Top Three Unknown Benefits of SAS Enterprise Guide

Are you familiar with these three powerful SAS Enterprise Guide features? If you are, then you already know what I am talking about. Once I asked SAS tech support “Could SAS Enterprise Guide …”, and discovered that yes, SAS Enterprise Guide can, I started to apply the features daily. I hope you too can benefit from my discovery. 

1 – Split the Workspace Screen to Compare Items

The first feature is the ability to split the workspace screen to view multiple windows, such as the SAS program and dataset or log files simultaneously. For me, cross-referencing SAS code with the SAS log and SAS dataset helps to provide a complete picture of my SAS program design. This benefit, combined with the second benefit, reinforces that SAS Enterprise Guide is not just for non-technical professionals, but also for the SAS programmer die-hards!

2 – Save Multiple Queries

The second feature is the power to save queries of multiple intermediate datasets such as sorts and filters for each data review step within a SAS program. For example, there could be missing values or patients with data issues that may cause unexpected results. SAS has a built-in system for us to trouble-shoot our SAS programs with step-by-step review of each intermediate dataset. What a concept! Without this great feature, you would have to ‘re-invent’ the wheel for each condition, select variables and sort query datasets for the debugging purpose of eachstep. Who can remember all of these details or has the time to retype the SAS code?

[Check out this free resource that compares SAS Enterprise Guide vs. SAS Display Manager at the SAS Savvy site.]

3 -Use the Ordered List

The third and final feature is the ability to run production SAS programs using the ORDER LIST option. Most organizations have a sequence of SAS programs they need to run on a regular basis. Who wants to manually submit each SAS program? This is a waste of time since you would not only need to monitor when the SAS program is done, but also need to track which SAS program to run next.

Learn More Tips at SAS Savvy

Look for these and more effective SAS tips on SAS Savvy. Get a free one-month trail membership at  SAS Savvy member. If you are just starting with SAS – you should explore this site for some great tips and training.

Never miss a BI Notes post!

Click here for free subscription. Once you subscribe you'll be asked to confirm your subscription through your email account. You email address is kept private and you can unsubscribe anytime.

Tags:

9 Comments »

  • Alice Cheng says:

    Thank you, Tricia for looking into this matter!

    The only work around I can think of at this point is to create another dataset with the subset condition I want. The pointing and clicking, as well as, looking through the entire list of variables in order to find the variable I want actually slows me down. This is especially so since variables are not listed in alphabetical or any order at all. (Maybe order when the variables are created?)

    I really appreciate your effort to look into this matter!

    Thanks,

    Alice

  • Alice:
    Thanks for sharing your viewpoint. I’ll try to think of some workarounds and blog about it in coming weeks. It might make the tool a little easier for you to use. I cannot promise it will totally replace the DM command area!

    You might also try checking in Sunil SAS Savvy site to see if he has some workarounds listed already.

    Tricia

  • Alice Cheng says:

    Thank you, Tricia for your comment.

    I know one can write codes with SAS/EG. I have done that by selecting File pull down menu, then select new, then select code. You can then write your code and submit it just like in SAS windowing environment. In fact, you can select your output to be in pdf, HTML, rtf, etc. formats.

    As a SAS programmer, I greatly miss the opportunities to use my SAS command in EG, which one can easily accomplished in SAS Windowing environment. A lot of times, I have to query data and it seems the query features only allow you to select the variables but not a function of a variables like substr(x, 1, 3), which I badly miss. And unlike view tables which variables are listed in alphabetical order for you to select, it seems in EG, variables are not ordered in ways that can be easily located.

    I wish SAS/Enterprise Guide can also incorporate some features from SAS Windowing environment so that users can take advantages of features in both environments.

    This is just my 2 cents.

    Thank you again for your comments, Tricia.

    Alice

  • Alice:
    Good question. You can just use code in EG like you do with Display Manager. There is not a concept of command line with EG – or at least not one I have found.

    Here’s an example of using EG to code.

    Tricia

  • Alice Cheng says:

    Hi, Sunil,

    With SAS/Enterprise Guide, is it possible to include functions in your query? Say I would like to see observations with upcase(substr(x, 1, 3))=’ABC’ (or upcase(X)=: ‘ABC’; ) Is that possible with SAS/Enterprise Guide?

    Can I somehow get the command line, like the one we used to in SAS Windowing Environment?

    Thank you in advance for answering my questions.

    Alice

  • Thanks for commenting SAS Nerd!

  • Kirk Paul Lafler ("sasNerd") says:

    Great tips Sunil!

  • I had the same reaction when I first discovered that feature as well. 🙂

  • Quentin says:

    Wow, tip #1 makes me SOOOOO happy. I’m 3 months (?) into using EG periodically, and hadn’t realized I could see both the program and log at the same time (as you can in DMS SAS). But looks like it is as easy as View->Workspace layout->Side by Side (for my wide monitor). Great tip, which will lead me to much less cycling between tabs when developing code. Thanks.