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
If you have not yet discovered the new Ask the Expert series on the SAS Training site, you are missing out on a treasure. Visit the site right now and review all of the available topics, from "Newbie" to Analytics to Visualization to good ol' SAS programming. Go on; I'll
Are you a VIEWTABLE fan from the SAS Windowing Environment (a.k.a. Display Manager, DMS, PC SAS)? If so, the latest version of SAS Enterprise Guide has a new feature that you'll love. With the latest update to SAS Enterprise Guide 7.1 (7.11), you can now subset your data in the
Copy/paste is my favorite method for creating new SAS programs. In my work projects, I maintain a sort of genealogy of SAS programs, because the DNA of one program can be used to spawn many other SAS programs as its progeny. When things (inevitably) aren't working as I intend in
Tucked in the SAS Enterprise Guide Query Builder there is a text box unhelpfully labelled 'Options'. To find it select Options -> Options for this query -> General, and it is about halfway down the screen. I am going to show you how to use that text box to make your tables smaller, and how
If you have SAS Enterprise Guide and SAS for Windows installed on a machine together, they should Just Work. There is no special setup required. But...what if they don't? I've posted an article in the SAS Enterprise Guide community about this topic. Read the article to learn: How to select
SAS Enterprise Guide 7.1 began shipping last week. Of the many new features, some are "biggies" while others are more subtle. My favorite new features are those for SAS programmers, including several items that I've heard customers ask for specifically. I'll describe them briefly here; the SAS Enterprise Guide online
Most organizations enjoy a plethora of SAS user types—batch programmers and interactive users, power users and casual—and all variations in between. Each type of SAS user has its own needs and expectations, and it’s important that your SAS Grid Manager environment meets all their needs. One common solution to this
SAS users love to look at data. And the data grid in SAS Enterprise Guide is a convenient way to view the contents of a data set. While small data sets can be rendered lickity-split for quick viewing, sometimes people get justifiably anxious when opening very large data. Perhaps they've
This probably won't surprise any of my regular readers: "SAS custom tasks" is one of my favorite topics to talk about. Since 2007, I've written blogs about how you can use custom tasks to extend SAS Enterprise Guide and the SAS Add-In for Microsoft Office. I've shared lots of examples,
I wish I had a nickel for every time I heard this question at SAS Global Forum: "So, does this SAS Studio thing replace SAS Enterprise Guide?" SAS Studio is a pretty big deal. It's groundbreaking in several ways: It's a web-based programming interface to SAS. It runs in your
As I was preparing for a customer introduction to using SAS Enterprise Guide, I asked them to send me all the questions they had regarding the Enterprise Guide usage. It turned out that many of their questions can be answered with a single feature called an autoexec, or automatically executable
When you run a program or task in SAS Enterprise Guide, the application wraps your job in an "ODS sandwich", the colloquial term we use for the ODS statements necessary to create output that can be viewed in your project. That's convenient for exploring and refining your program, but at
My teenage daughter is a self-appointed anglophile. She's a big fan of British movies and TV shows such as Doctor Who and Sherlock, and although she has not yet visited the UK (an injustice for which she blames her father), she considers the place to be her homeland. In an
Liebe Leser, in dieser Woche war ich auf großer Deutschlandtour mit der Enterprise Guide Roadshow „EG on Tour“. Vielleicht habe ich ja einige von ihnen dort gesehen. Sollten Sie diese Gelegenheit verpasst haben: Die nächste "EG on Tour" ist schon in Arbeit. Die Tour führte von Berlin über Hamburg nach
Last week's SAS Talks session, My Favorite SAS Enterprise Guide 5.1 Tricks, was remarkable in several ways. First, the featured presenter was Marje Fecht, who also serves as the conference chair for SAS Global Forum 2014. She's an avid SAS professional who loves to educate her fellow SAS users on
This isn't the first blog post to laud the "Note" feature of SAS Enterprise Guide. You know, the feature that allows you to add documentation to describe what the heck your project or process flow is actually doing. For example, Tricia described 3 useful ways to use the note feature.
SAS Enterprise Guide and SAS Global Forum -- two of my favorite things! And I get to talk about both of them in this post. I'm a devoted SAS Enterprise Guide user, and I hope you're learning how useful this tool can be as well. On February 13, I'll be sharing
Recency, Frequency, and Monetary Analysis (or RFM) is a popular customer segmentation technique employed by database marketers everywhere. Marketers use RFM to identify which customers are most likely to respond to a direct marketing campaign. The model takes into account three simple metrics: How recently did the customer buy from
The holiday season is here, and you're probably wondering how to shop for that picky SAS Enterprise Guide user on your gift list. I've got a few ideas for you, and the price is right! Here are links to 11 custom tasks that are free to download, easy to install,
It's been almost 5 years since I posted one of the first custom tasks for SAS Enterprise Guide. It was a task that made it easier to convert SPSS data files into SAS data sets. Like many projects that begin as custom tasks, this one later became a feature in
Teil 1: Performancekiller Der SAS Enterprise Guide ist ein sehr intuitives und trotzdem ausgesprochen mächtiges Graphical User Interface. Neben einer kompletten Programmieroberfläche, bietet er eine Menge Point- and Click Anwendungsroutinen, durch welche man vom Einlesen von Excel-Dokumenten, über SQL-Abfragen, bis hin zu komplexen Grafiken und Vorhersagemodellierungen, mit ein paar Klicks alles erreichen
With the release of SAS 9.4 (which included SAS/STAT 12.3 and SAS Enterprise Guide 6.1), you might seriously consider hiring a Chief Versions Officer (CVO). Fortunately, most of the recent versions of SAS Enterprise Guide work with the different recent versions of SAS, so you have some flexibility as you
Many SAS Enterprise Guide users practically live in the Query Builder. For those who understand their data tables, the Query Builder provides a tremendous amount of flexibility to pull and manipulate data. The Query Builder produces SQL programs behind the scenes, which translates well for database-centric work. Sometimes a complex
Last week I alluded to some very useful applications of the Copy Files task. This is one of them. If you have SAS Enterprise Guide 7.13 or later, the Copy Files task is in the Tasks->Data menu. In earlier versions, you'll have to download/install the task as a custom task.
A few months ago I released the Copy Files task for use with SAS Enterprise Guide. The task allows you to transfer any files between your PC and a SAS Workspace session, much like an FTP process. It doesn't rely on FTP though; it uses a combination of SAS code,
Even though it's been around for well over a decade, SAS Enterprise Guide was still a hot topic among attendees at SAS Global Forum this year. In the Technology Connection -- the big session on Monday morning -- SAS R&D staff used the conference agenda content to demonstrate the power
Last week I delivered a SAS Talks session: Introduction to Custom Tasks for SAS Enterprise Guide (click to watch it). I promised that I would share a collection of resources where you can learn more information. First, here is a round-up of the custom tasks that I mentioned, with links
If you're using SAS Enterprise Guide and you're not using custom tasks, you're missing out! Custom tasks are new features you can plug in – features that weren't originally packaged with the software. (And contrary to the Pulp-O-Mizer poster that I created, they do not come FROM OUTER SPACE. Usually.)
I've got a new trick that you can use to track progress in a long-running SAS program, while using SAS Enterprise Guide. I've previously written about the SYSECHO statement and how you can use it to update the Task Status window with custom messages. SYSECHO is a "global" statement in
