One SAS Enterprise Guide feature I particularly like is the ability to import Microsoft Excel data quickly and easily. SAS offers many ways to work with Excel spreadsheets but often I find I just want to extract data from Excel and get on with my job. Tip – Click on any picture to...
Read More »
As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide. I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common...
Read More »
Some may not realize that you can edit a SAS Stored Process in multiple ways (depending on your permissions). Today I show you three different ways to reach the stored process code. By the way, I’m using SAS Enterprise Guide 4.3 and SAS Management Console 9.3 – so your windows may look different. Method...
Read More »
To pick the winners of the 50 Keys to Learning SAS Stored Processes book, my first thought was to print the list and then put everyone’s name in a hat. Angela brilliantly suggested that we use one of the SAS Random functions. However, since there was a list of names I really needed a...
Read More »
In the midst of writing our first book, Angela and I argued over the stored process chapter content. After we wrote the chapter outline, we then wrote the outline for this book. The first title was the 25 Best Tips for Writing Stored Processes. Our idea for the tips, which later became keys, was simple:...
Read More »
In an earlier post, I provided a check log program that you could use with your batch jobs. There was some really interesting discussions in the Comments about using SAS Enterprise Guide with the log. Here’s some tips I have for working with the SAS Enterprise Guide logs – everything from some quick tips...
Read More »
I created a LogCheck macro to review the log during a batch process. The SAS log files can be rather large and it is so much easier if you can just extract the issues in an easy to understand format. This macro reads in each line of the log file and keeps...
Read More »
Last week at Insurance and Finance User’s Group (IFSUG), I caught up with Sunil Gupta, a SAS Press author and a SAS expert. He was chairing one of the sections and presenting some information himself, which Angela Hall and Waynette Tubbs discussed in their blogs. However, Sunil is a busy man – the week...
Read More »
Yes, you can import a spreadsheet into SAS Enterprise Guide and it’s super simple. However, there are times when I have been building datasets from several pieces of data and need to scrape bits and pieces from here and there to add to my dataset. Come into my lab … now that I’m a...
Read More »
There are some helpful options you can set in SAS Enterprise Guide to make your day-to-day coding tasks a little quicker. Some of these tasks can impact stored processes you create from tasks instead of coding. SAS Enterprise Guide Options From the Tools > Options menu you can preset options such as footer text...
Read More »
