Tag: Enterprise guide

Oh Snap! Upload Data to the LASR Server Just Like That!

In a past life I worked at a company who had an excellent general manager, she was professional, intelligent, and a role model. It was a small company competing with giants and kicking their butt successfully. She set a new mission for the organization –  we needed to not only meet a customer’s product needs but also delight them in the process. Its hard to …

This post appeared first on BI Notes for SAS Software Users. Go to the site to subscribe or view more content.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is the difference in SAS Visual Analytics and SAS Enterprise Guide?

Those considering moving to SAS Visual Analytics often quiz me about how it is different from SAS Enterprise Guide. While SAS Enterprise Guide can duplicate some SAS Visual Analytics functionality – it’s not the same. This post I’m going to explore the principal purpose of each tool to help explain how they are alike and different.

What is SAS Enterprise Guide?

SAS Enterprise Guide (EG) is a development …

Post What is the difference in SAS Visual Analytics and SAS Enterprise Guide? appeared first on BI Notes for SAS® Users. Go to BI Notes for SAS® Users – Providing resources for SAS® BI and Visual Analytics Users to subscribe. Copyright Siamese Publishing. All Rights Reserved.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

NOTE: Your Response: EG & Studio

As Mark Twain is oft (incorrectly) quoted as saying: “Reports of my death are much exaggerated”. I didn’t say that Enterprise Guide (EG) was anywhere close to death when I (contentiously) wrote NOTE: What is SAS Studio? RIP Enterprise Guide? but I…

SAS Enterprise Guide: Suppress Output Data tab when programming

Have you ever waited a bit for SAS Enterprise Guide to display the Output Data tab when submitting a SAS program that generates multiple output tables?  Or, perhaps your program only generates one big output table but it takes a little while for it to surface on the Output Data […]

The post SAS Enterprise Guide: Suppress Output Data tab when programming appeared first on The SAS Training Post.

Applying conditional highlighting to a SAS Enterprise Guide report

Here’s my latest tip on how to apply conditional highlighting to a SAS Enterprise Guide report using the Summary Tables task. The Summary Tables task is a great way to point and click your way to creating simple or complex reports. Conditional highlighting is just one additional feature you can […]

SAS Format Viewer and Others (EG)

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 […]

NOTE: Enterprise Guide vs DI Studio – What’s the difference?

A favourite interview question of mine is: Compare and contrast SAS 9’s stored process server and workspace server. This question is very good at revealing whether candidates actually understand some of what’s going on behind the scenes of SAS 9. I mentioned this back in 2010, together with some notes on my expectations for an answer.

I was amused to see Michelle Homes post another of my favourite interview questions on the BI Notes blog recently: What’s the difference between SAS Enterprise Guide and SAS DI Studio? This question, and the ensuing conversation, establishes whether the candidate has used either or both of the tools, and it reveals how much the candidate is thinking about their environment and the tools within.

For me, there are two key differences: metadata, and primary use.

Michelle focuses on the former and gives a very good run-down of the use of metadata in Data Intergration Studio (and the little use in Enteprise Guide).

With regards to primary use, take a look at the visual nodes available in the two tools. The nodes in DI Studio are focused upon data extraction, transformation and loading (as you would expect), whilst the nodes in Enterprise Guide (EG) are focused upon analysing data. Sure, EG has nodes for sorting, transposing and other data-related activities (including SQL queries), but the data manipulation nodes are not as extensive as DI Studio. In addition to sorting and transposing, DI Studio offers nodes that understand data models, e.g. an SCD loader and a surrogate key generator (I described slowly changing dimensions (SCDs) and other elements of star schema data models in a post in 2009). On the other hand, EG has lots of nodes for tabulating, graphing, charting, analysing, and modelling your data.

One final distinction I’d draw is that EG’s nodes are each based around one SAS procedure, whilst DI’s nodes are based around an ETL technique or requirement. You can see that DI Studio was produced for a specific purpose, whilst EG was produced as a user friendly layer to put on top of the SAS language and thereby offers a more generalistic solution.

For the most part, I’m stating the obvious above, but the interview candidate’s answer to the question provides a great deal of insight into their approach to their work, their sense of curiosity and awareness, and their technical insight.


Follow me on Twitter: @aratcliffeuk

See an audiovisual recording on my SAS Global Forum 2013 paper Visual Techniques for Problem Solving and Debugging

Your Resume–Selling Yourself Using SAS

Here 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 […]