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 » Coding & Data, Enterprise Guide

Killer New Log Summary Feature in SAS Enterprise Guide 6.1!

Submitted by on 2013-07-22 – 7:05 AM 3 Comments

Hey brilliant SAS Institute developers – I love your new SAS Enterprise Guide 6.1 Log Summary feature!  When I was reading through the What’s New in SAS 9.4 for SAS EG 6.1 there were only a few entries.  But BAM! the second bullet made me run over to the demo machine to see what I was missing:

  • improved programmer productivity with the new Log Summary window, which lists all the errors, warnings, and notes that were generated when the program ran, as well as related line numbers and a sample of the affected code.

Killer Log Summary Feature

Basically after running a program, you can visit the Log tab and click the Log Summary button for a quick view of what just happened.  Seriously – look at the following graphic – the Log Summary area shows the number of Errors, Warnings, and Notes from the log.  This extremely simple program only generated 3 Notes.  Notice when I click on the line – it highlights the associated line in the log.  How cool is that? [Yes – it’s okay to dance around!]

SAS Enterprise Guide 6.1

What if There are Errors in the SAS Log?

I’m sure most of you rarely make any coding errors, so just pass this tip along to those less skilled than you.  I generated an error in the code to see what would happen.  Of course the Log Summary buttons give me a count of the errors and warnings.  However, those buttons also allow control of the detail – so if I click the Errors button the log is filtered to just show the errors.  I can then click the Warnings button to also see the warnings.

This is a small log so it’s not as impressive as when you have pages, pages, and pages of logs and you need to understand the root of the issue. There should be a smile on your face now.

SAS Enterprise Guide 6.1 Log Summary 

Other Neat Tricks

Here’s some other uses you may not have thought of yet. 

Check the Observations

If you filter the Notes, you can quickly see the counts from the datasets. Many times I have to read in data where I start with 100 rows and I need to end with 100. This allows you to quickly view the log to check for the count instead of doing the Search/F3 dance through it.

SAS Enterprise Guide 6.1 Log Summary Observation Count

Check Other Logs

If you need to check a troubled batch or SAS Stored Process log that was created separately, the Log Summary can handle it.   Make sure the file extension is “.log”. From SAS Enterprise Guide, use the File>Open>Other to add it to your project.  Very easy to see where things went wrong!  [Need a log check program for batch?]


Learn More about SAS Stored Processes and Prompts

You can learn more tips and tricks for creating, debugging, and using SAS stored processes in the 50 Keys to Learning SAS Stored Processes book. It's a complete guide to SAS stored processes. Check Amazon for best pricing and quick shipping!

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: ,

3 Comments »

  • Tricia says:

    Seems appropriate ..

    A guy is standing on the corner of the street smoking one cigarette after another.

    A lady walking by notices him and says “Hey, don’t you know that those things can kill you? I mean, didn’t you see the giant warning on the box?!”

    “That’s OK” says the guy, puffing casually “I’m a computer programmer”

    “So? What’s that got to do with anything?”

    “We don’t care about warnings. We only care about errors.”

  • I made the request to Vince DelGobbo already! I know he submitted it to Development – so we will see!

  • Nice to have a built in log analyzer. There have been a number over the years. I’ve used the one from Savian as well as one written by David Shinn in SAS TS.

    A question for you (since it will be a while before I can install 9.4), does the log window include columns for the number of input and output rows? As well as the CPU and Real time? And, if so, can you sort on them to identify the parts of the program that are using the most resources?