Why code when %_eg_WhereParam does the work for you?

Angela Hall
Angela Hall|March 14, 2012

After unwittingly getting involved recently in a code vs GUI discussion another pro GUI vote came in yesterday when presenting to a customer’s internal user group. When creating and using prompts in SAS Enterprise Guide, it is a no-brainer to recommend leveraging the %_eg_WhereParam as it handles all the special [...]

Post a Comment

Use SAS Enterprise Guide to quickly understand a new data set

Angela Hall
Angela Hall|March 7, 2012

During IFSUG yesterday, Sunil Gupta gave attendees to his presentation a special homework assignment. Look into the SAS Enterprise Guide task ‘Characterize Data’. Sunil suggested that this was a simple approach to quickly getting a summary of all the variables within your data table. Of course, some programmers will use [...]

Post a Comment

Revisiting the starting file location for Enterprise Guide

Angela Hall
Angela Hall|October 27, 2011

Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would prefer to use a central [...]

Post a Comment

Tip on creating graphic files in specific locations

Angela Hall
Angela Hall|September 16, 2011

When trying to write out graphics to a specific filename location, the gsfname option is only honored when ODS LISTING is turned on and ODS HTML is turned off. This is especially important in 9.3 Base SAS as the ODS HTML option is the default output destination. Enterprise Guide users [...]

Post a Comment

Enterprise Guide 4.3.1 and 9.3 Stored Processes

Angela Hall
Angela Hall|August 26, 2011

Chris mentions in his FAQ post on 9.3 and Enterprise Guide that the new stored processes and other new metadata can not leverage all of the functionality in the new 9.3 release.  EG is nice to remind us of that fact when we open the SAS Folders view with the [...]

Post a Comment

Making OLAP Drill Through to Detail Data Available as Dataset in EG Project

Angela Hall
Angela Hall|July 14, 2011

In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow includes navigating through [...]

Post a Comment

Program formatting in Enterprise Guide 4.3

Angela Hall
Angela Hall|December 20, 2010

As Chris Hemedinger has written in several of his blog posts, SAS Enterprise Guide 4.3 has many more formatting options. I particularily enjoyed the ‘CTRL-i’ option to reformat SAS code with indents and carriage returns to make my programs even more readable. The ‘CTRL-e’ and ‘CTRL-SHIFT-e’ keyboard shortcuts are also [...]

Post a Comment

Exporting last submitted code from Enterprise Guide

Angela Hall
Angela Hall|June 23, 2010

You can export the .sas code from a specific task or the entire project into a .sas file! It’s great when publishing a project into a repeatable batch/schedule process. However, be aware of default names for the .sas resulting file. I recently ran across an error when exporting a task [...]

Post a Comment

Editing Tasks in a Reopened EG 4.2 Project

Angela Hall
Angela Hall|November 2, 2009

In the new SAS Enterprise Guide 4.2 Project, I have found that before making modifications to a reopened project, run the process flow once (or through to that particular point) so the necessary work data table is available. Certain tasks, if opened when the work table doesn’t currently exist, will create [...]

Post a Comment

Shared Prompts in SAS BI 9.2 ~ Modifying via EG 4.2

Angela Hall
Angela Hall|October 12, 2009

After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (http://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the ‘Server List’, there is a small blue circle with a 1-2-3 and when you mouse over you will see ‘Prompt Manager’. When adding [...]

Post a Comment