Posts Tagged ‘ analytics consulting ’

SAS Altlog option

April 21, 2011
By

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 »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off

Making SOAP calls from SAS! Integrating with web services

March 31, 2011
By

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 »

Tags: , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS / Teradata Fastexport – dbsliceparm = all

November 11, 2010
By

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 »

Tags: , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS: Where Also

August 9, 2010
By

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 »

Tags: , , , , , , , , , , , ,
Posted in SAS | Comments Off

Pivot tables and Cheezy Graphs? No more…

February 16, 2010
By

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 »

Tags: , , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS INTNX function ( add days, months, years, etc )

December 3, 2009
By
SAS INTNX function ( add days, months, years, etc )

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 »

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS DIM function – Counting the elements in an array

October 30, 2009
By

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 »

Tags: , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.