SAS stored processes are similar to SAS programs in that they use the same programming language. Many of my SAS programs I created early on were only used by me, so I could live with a little uncertainty and it was easy enough to check the logs for any issues. If anything went wrong...
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 »
Maybe you are like me and your SAS programs frequently bounce from PROC SQL to data steps depending on the task at hand. Some things you cannot do in PROC SQL as easily as the data step and vice versa. Here’s 3 data set tricks that I have successfully used with PROC SQL. These...
Read More »
In honor of Easter, here’s a rare egg for the BI Notes blog – information about SAS statistical products! Today guest blogger Phil Low offers some insight about some of the other SAS procedures, particularly those used for the forecasting. Would You Manually Forecast 60,000 Data Items? Ever wake up to find you have...
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 »
Here is a quick tip for keeping the WORK library clean in a UNIX/Linux environment. Most of the time SAS manages the cleanup process very well but sometimes orphaned processes can leave unwanted data lying around which can build up over time. This tip is only applicable for UNIX or Linux environments. SAS does...
Read More »
Check out the results of my SAS Enterprise Guide code – 41 days til SAS Global Forum 2012 in Orlando, Florida! I’m excited – I can’t wait to meet some of my Web friends face-to-face finally! Oh and also catch up with some of my old buddies! Why Should I Attend SAS Global Forum?...
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 »
Working with account numbers can require adding a leading zero. You can use the Z format but it can be a little tricky. Not so long ago I showed you how to use the Z format to create a new data item in Information Map Studio. However, I noticed many people are still searching...
Read More »
I’m delighted that Phil Holland, Holland Numerics, has written a guest post today. Phil, clearly a SAS icon, is the author of numerous SAS books that are available from multiple sources. He recently expanded his work into some new and exciting formats, which he is discussing in this post. Writing SAS Books Let me...
Read More »
