Tag: SAS Enterprise Guide

HAVING (clause) fun with 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 […]

The case for XCMD privileges in SAS Enterprise Guide

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

How to get your SAS data set attributes into Excel

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

User Groups: WUSS meets in Hollywood this Year!

Okay – not exactly Hollywood – but it’s only 30 minutes away – so you could visit during the evening or stay the weekend after the conference to do some star-sightings.   Long Beach is outside of Los Angeles and close to Hollywood!  It’s not too late to sign up for the Western Users of SAS Software (WUSS) conference in Long Beach, CA the same week as Labor Day (Sept 5 -7). Early registration ends August 6, but for a few extra dollars you can register anytime this month.  I spoke with Scott Leslie, the Academic Program Chair, earlier this week and it’s excited about the conference and reminded me of all the great things going on.  I had a few questions for him.   Will Captain Kirk be There? Scott could not confirm if Bill Shatner or Leonard Nimoy would make an appearance but SAS Institute is sending some of their superstars.  You can see complete details at the SAS Presenter’s page – here’s some highlights: Diane Hatcher is presenting information about how to set up a report approval process using the new  SAS® 9.3 Integration Technologies.   Allison Booth provides some tips for using Proc Report.  She’s a great speaker and don’t […]

How to get the statistics you need from SAS Enterprise Guide

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

Listing the data sets in a library within your custom task

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

Password Encoding with SAS

Quick note from Paul: I’m really excited that platformadmin.com’s very first guest post is from the well known blogger and author Tricia Aanderud. I suspect you already know Tricia, but just in case you don’t … Tricia Aanderud, …

SAS Enterprise Guide: Writing Code to Capture New Twitter Followers

While at the SAS Global Forum, someone said to me – “You cannot write code in SAS Enterprise Guide.”  It was a little shocking to me that the person thought SAS Enterprise Guide was all wizards, flow diagrams, and magic. After talking to a few other folks I have found that it is a common myth.   News Flash!  You can just code in SAS Enterprise Guide!  Today I’ll show you how I pull data from Outlook into SAS Enterprise Guide to create a tweet.  And I’m just going to code. Mythbuster! You can Code in SAS Enterprise Guide If you tweet a lot then you might be familiar with the #FF hashtag. It means people the Tweet-er suggests that you follow. Lately I have been getting more Twitter followers and some I think are really worth checking out.  However, trying to cut and paste all the names into a tweet is a buzz kill.   Here’s how I automated my process with SAS Enterprise Guide.  By the way – if you think I could add some efficiency to my code – speak up in the comments (with examples please!)  Step 1: Setup a MS Outlook Rule Here’s the initial process: […]