To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does…
Tag: Uncategorized
Hats and apps on tap for my #SASGF13
When I travel to San Francisco in April for SAS Global Forum 2013, it will make my 12th time to attend the international SAS users group conference, and my 7th consecutive year. A lot of people assume that I automatically go every year, but the truth is that SAS employees […]
Never lose track
The SAS Online Customer Support Home page is like O’Hare International Airport — once you get there, you can go almost anywhere else. If you have a layover before you leave the airport, you have lots of opportunities for a good meal, some great shoppi…
Tracking tornadoes with SAS
We had some fierce wind storms all across the United States yesterday, which even spawned some tornadoes! It looks like we weathered the storm OK here in Cary (but I still need to run out to the lake and make sure my pontoon/houseboat is still there, …
Getting to Know You: New Text and Content Analytics Community
We know that many of you are active users of the Support Communities on the site and are pleased to tell you there’s a new community in town: Text and Content Analytics. This community is a centralized resource for discussing ideas, asking questions, s…
Tracking progress in your program with SAS Enterprise Guide: another trick
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 […]
An easy way to find variables in common to data sets
Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, …
How to search your SAS Enterprise Guide projects (2013 version)
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 […]