Category: SAS

Create Oracle Tables

libname oradb Oracle User=orauser Password=xxxxxxx Path=”@orapth”; proc sql;&nbsp &nbsp &nbsp create table oradb.dsn as&nbsp &nbsp &nbsp select * from temp;quit;run;proc append base=oradb.dsn data=temp1 force;run;

Decision Trees in SAS Enterprise Miner and SPSS Clementine

Decision trees are included in SAS Enterprise Miner(EM). The counterpart is SPSS Clementine, which should be called IBM SPSS Modeler for precision after IBM’s acquisition of SPSS.
Recently I read a paper on the comparisons of SAS EM, SPSS Clementine and IBM Intelligent Miner on their decision tree and cluster technology:
Decision Tree Induction & Clustering Techniques […]

Bayesian Computation with SAS (1).

The book “Bayesian Computation with R” by Jim Albert is an easy to read entry level book on applied Bayesian Statistics. While the book was written for R users, it is not difficult to translate the languages between R and SAS and I believe it is a go…

Example 8.19: Referencing lists of variables

In section 1.11.4 (p. 50), we discuss referring to lists of variables in a data set. In SAS, this can be done for variable stored in adjacent columns with the “var_x — var_y” syntax and for variables with sequentially enumerated suffixes with the “va…

What’s that color?

There are times when I’m looking for the right color to highlight an item or otherwise make output beautiful. As a result, I am always struggling to find good colors to use in my output. SAS Support to the rescue.

They have created a program that dis…

SAS Data Step’s Built-in Loop: An illustrated Example

Some newbie SAS programmers take SAS as their first programming language even learned. Sometimes they are confused by the concept of “data step’s built-in loop” even after reading the well-written The Little SAS Book: A Primer:
DATA steps also have an underlying structure, an implicit, built-in loop. You don’t tell SAS to execute this loop: SAS […]

Welcome Welcome

I had great plans for how to close out 2010 here in the blog. None of those plans moved from the To Do list to the Done list. So now, before the fireworks, popping corks, and noise makers, let me take a moment to say “Happy New Year.”

Thanks …