The project that I'm currently working on requires several input data tables, and those tables must have a specific schema. That is, each input table must contain columns of a specific name, type, and length in order for the rest of the system to function correctly. The schema requirements aren't
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
When the Western Users of SAS Software gather in Long Beach, CA this September, I'll be proud to be counted among the WUSSers. (You can learn more about WUSS here; don't look here.) The WUSS organizers must have some serious clout, because the line-up of presenters reads like a "Who's
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
With the London 2012 Olympics around the corner, there are sure to be reports or rumors of performance-enhancing drug use among some athletes. It turns out that using manufactured chemicals to give yourself an edge is frowned upon in the athletic community. However, as a SAS user you should avail
If you've heard anything from SAS in recent months, then you've heard about high-performance analytics and the new SAS Visual Analytics offering. SAS has taken the high-performance analytics message around the world in a series of recent "road shows". From the start, this project has enjoyed a different development process
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
"Welcome to the English summer." "In the US you have climate. In England we have Weather." These are just two of the familiar phrases I heard yesterday during the SAS Professionals Convention held at SAS UK in Marlow. The weather changed from sun to dark clouds to rain and even
Update 24Nov2015: The methods in this post no longer work for Twitter, as Twitter has discontinued support for its "share count" API that was used within the Twitter share buttons. But the Facebook method still works, and I've described a method for counting LinkedIn shares on another post. As of
A colleague was recently working with a web service that supplies some datetime values using the Microsoft Windows internal representation. He called the web service to retrieve those values (along with other data) from SAS, and he needed convert these values to SAS date-time values. The Microsoft definition for a
