“Frankenstorm” is what the U.S. National Weather Service is calling the combination of Hurricane Sandy, an early winter storm heading east, and a blast of arctic air from the North. SAS headquarters is located in the middle of the U.S. east c...
Read more »
The TIOBE Community Programming Index ranks the popularity of programming languages, but from a programming language perspective rather than as analytical software (http://www.tiobe.com). It extracts measurements from blogs, entries in Wikipedia, books on Amazon, search engine results, etc. and combines them into a single index. … Continue reading →
Read more »
The open source R software for analytics has a reputation for being hard to learn. It certainly can be, especially for people who are already familiar with similar packages such as SAS, SPSS or Stata. Training and documentation that leverages … Continue reading →
Read more »
Learning to use a data analysis tool well takes significant effort, so people tend to continue using the tool they learned in college for much of their careers. As a result, the software used by professors and their students is … Continue reading →
Read more »
If you run a production SAS environment or even a development environment for that matter, it is nice to have a specific location for all logs to be written and managed. ALTLOG helps achieve this. The ALTLOG option can be set numerous ways, but we typically utilize 2. 1. As an option on the...
Read more »
We write a LOT of SQL here and although SQL is a powerful database language, it can be tedious. So here is one tip for shortening all that typing. Typical join sytax: select some_columns from one_table join another_table on one_table.column_1 = another_table.column_1 and one_table.column_2=another_table.column_2 where some_column > someother_column ; Not too bad, right? In order...
Read more »
Fastexport is the fastest way to get large data out of teradata. Fastexport utilizes multiple connections to deliver data and therefore speeding up the transfer of data between Teradata and SAS. Here are a few examples of fastexport. /* libname statement*/ libname teradb teradata username=&un password=&pw dbsliceparm=all; /* explicit sql */ proc sql; connect...
Read more »
Like John Sall, I'm wearing my "I <3 STATISTICS" pin today... and I'm not even a statistician. When I tell new acquaintances that I work at SAS, I usually get one of these responses: “Oh that's nice. I've never heard of them.” “Oh that's nice...
Read more »