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,
Okay, given the title of this article, I might be overselling the content a bit. Read on to see if your life will be transformed. I've just returned from SESUG, and this question came up during one of the presentations. While this tip might seem basic, it was news to
The other day I showed how to check your data cardinality by using a simple SAS program. I also promised to provide a custom task that makes the process even easier within SAS Enterprise Guide. Today I'm delivering on that promise. I've just added the custom task to the support.sas.com
Traditionally, SAS users like their processes to behave like Ron Popeil's famous rotisserie: they want to set it and forget it. That's the definition of a batch process. You work like heck to get it ready to run, then you push the button (or schedule it) and walk away. But
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
If you're a software developer, you're probably already familiar with these terms: I18N and L10N. Internationalization (I + 18 letters + N = I18N) The discipline of preparing your software to run correctly in different languages with different culture settings. For example, the software must be able to accommodate multibyte
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
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
Last year I published an example application for searching your SAS Enterprise Guide project files (EGP files). The example shows off some of the cool features of the automation API, and it's a useful tool. As neat of an example as that was, it had some limitations. It worked only
I've bragged about how easy it is to install custom tasks for SAS Enterprise Guide. It's simple: you copy the .NET assembly (usually a single DLL file) into one of the designated folders in your SAS Enterprise Guide installation, and your task just shows up in the menu. Since I
This week's SAS tip is from Susan Slaughter and Lora Delwiche's bestselling The Little SAS Book for Enterprise Guide 4.2. Susan and Lora are revered in the user community. And their work continues to help SAS users throughout the world. I hope you'll also find value in this week's excerpt. The following excerpt is from
I work on a variety of projects at SAS, most of which require some level of team collaboration in source management systems. Due to the many technologies that we work with, SAS developers use different source management tools for different purposes. I've got projects in CVS, Subversion, and Git. When
You might know about the many automatic macro variables that are available in SAS. They provide plenty of information about the SAS environment, such as the current user (SYSUSERID), the SAS version (SYSVER and SASVLONG), and the operating system where SAS is running (SYSCP and SYSCPL). That information is often
Chris Hemedinger is not the only person who’s excited about the capabilities of SAS Enterprise Guide. Tom Miron, from Systems Seminar Consultants, a SAS author with more than 35 years of SAS experience, shared some great advice for using SAS Enterprise Guide.
Last week I attended a meeting of the Toronto Area SAS Society. (Okay, I didn't just attend; I was a presenter as well.) This user group meeting contained a feature that I had never seen before: "Solutions to the Posed Problem". Weeks before the meeting, an "open problem" was posted
One of the often-cited side effects of moving from "Base SAS" (SAS on your PC, or Display Manager) to SAS Enterprise Guide is the loss of "X" command privileges -- that is, the ability for your SAS programs to invoke other programs via the operating system shell. We call this
I'm working on a SAS programming project with a large team. Each team member is responsible for a piece of the overall system, and the "contract" for how it all fits together is The Data. For example, I've got a piece that performs some data manipulation and produces several output
If you need to calculate the mean, sum, standard deviation, or frequency count for a variable, you'll find it pretty easy to accomplish in SAS Enterprise Guide. The corresponding tasks in the menus have names like "Summary Statistics" or "One-way Frequencies". Obvious, right? Often, researchers or students have a quest
A SAS Professionals attendee and Twitter follower named Marco asks for help: ..struggling to find a method with custom tasks in EG to be able to list the datasets in a library, can you help please? Sure, no problem. This is easy-peasy-lemon-squeezy. First, make sure that you have a reference
If you are like many SAS Enterprise Guide users, you've amassed a large collection of project files (EGP files) that contain important content: programs, logs, notes, results, and more. However, to most tools and processes, the EGP file is opaque. That is, you can't see what's inside of it unless
It’s going to be a busy summer with a lot of travel. I’ve been invited to several user conferences so I’m really excited to get to meet even more SAS users, pick up some great tips for others, and wear myself out chatting.
This week's SAS tip features scatterplots of ice cream data. Geoff Der and Brain Everitt and their book Basic Statistics Using SAS Enterprise Guide offer up many intriguing examples. Besides analyzing ice cream consumption, the authors use heights and resting pulse rates, horse race winners, and brain tumors to illustrate statistical techniques. Emphasizing the practical
