Posts Tagged ‘ Database ’

SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory

October 3, 2012
By
SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory

By default, accessing third party relational databases can be very slow if not configured properly.  I recently started using PostgreSQL 9.1, an open source database, to store high volumes of data for my SAS Global Forum 2013 paper.  At first it was taking forever to load up data because SAS was inserting 1 row...
Read more »

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

Map and Reduce in MapReduce: a SAS Illustration

October 4, 2011
By
Map and Reduce in MapReduce: a SAS Illustration

In last post, I mentioned Hadoop, the open source implementation of Google’s MapReduce for parallelized processing of big data. In this long National Holiday, I read the original Google paper, MapReduce: Simplified Data Processing on Large Clusters by Jeffrey Dean and Sanjay Ghemawat and got that the terminologies of “map” and “reduce” were basically...
Read more »

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

An Analytical Valley: Big Data and Data Scientists (and SAS Programmers)

September 14, 2011
By
An Analytical Valley: Big Data and Data Scientists (and SAS Programmers)

Tom Davenport reported an observation that Silicon Valley is becoming more analytical since companies in the Valley such as Google, Facebook, eBay, LinkedLn all have strong presences in analytics. Besides such predominant companies, I’d also like to add Yahoo to the list although Yahoo is no longer in its peak. Yahoo is the largest...
Read more »

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

Who is Alfred?

August 31, 2011
By

Tell me something about Alfred, male or female? age? height and weight? Oracle database (version 9 and below) had a well known default demo account SCOTT with a password, TIGER (and TIGER was the name of the real person Bruce Scott ’s cat, see) and in this account, there are some tables named DEPT,...
Read more »

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

Work With Oracle: A Quick Sheet for SAS Programmers

December 4, 2009
By

(Note: All the followings are tested on Windows XP environment.) 0. Install Oracle Database 10g Express Edition Fast (and free) to download, easy to deploy and simple to admin–for learning and testing purpose, Oracle Database 10g Express Edition (Oracle Database XE, a mini version of Oracle Database 10g Release 2) are strongly recommended: 0.1 Download it...
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.