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 »
One of the issues with SAS for many IT departments is the lack of integration with service oriented architecture (SOA). The good news is with many new features coming online with versions 9.X+ are service oriented. Lets look quickly at the Proc SOAP procedure now available. For those SAS programmers out there that aren't familiar...
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 »
Ever heard of ‘where also’? Neither did we.
We have to give credit to the guys at the SAS Community.
‘Where also’ allows you to add a series of where statements. The use acts like a single where statement with the and condition....
Read more »
As any good analyst knows, working with data is not the problem. Good analysts have the skill necessary to combine, split, merge, slice, aggregate, or summarize data any way you can imagine. However, is that enough? Probably not.. What good does data do if you can’t communicate its meaning in a logical way. The...
Read more »
The INTNX function increments dates, times, or datetimes by specific or custom intervals. Here is the basic syntax for INTNX: INTNX(interval, start, increment) The interval can be a set value like – DAY, WEEK, DTWEEK, YEAR, etc. You can also specify a custom interval. We will post more on that later. The multiple...
Read more »
The DIM function returns the number of literal elements in an array. It functions against multi-dimensional arrays as well as one-dimensional arrays. 1-dimensional array example DIM(array_name) Multi-dimensional array examples DIM(m_array) -> returns the number of elements in the first dimension of the array DIM5(m_array) -> returns the number of elements in the 5th dimension...
Read more »