Posts Tagged ‘ teradata ’

In database processing is great! (when you use it!)

March 1, 2012
By

Netezza and Teradata are both great examples of distributed processing databases that combine the power of SAS with their own platform to deliver a powerful analytics tool. The problem? Clients rarely use it. We have seen several clients who possess this functionality. Some of who purchased the DB at the request of the analysts,...
Read more »

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

SQL tip – Inner join shorthand with USING

January 14, 2011
By

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 »

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

CRM technologies

January 11, 2011
By

As we begin to add posts in 2011, we stepped back to look at our business and our blog. We realized that the two are perfectly aligned. Although the majority of our focus is within the SAS product suite, our focus is marketing analytics and operations. Given that, it is time for us to...
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

What Exactly Does SAS In-Database Really Mean?

October 25, 2010
By
What Exactly Does SAS In-Database Really Mean?

Editor’s note: David Pope is a SAS Solutions Architect and is helping to support SAS at the M2010 Data Mining Conference working in the SAS/Teradata partner booth, highlighting our partnership and how SAS and Teradata work together. The Teradat...
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

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.