Tag: SAS

SQL tip – Inner join shorthand with USING

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 for […]

CRM technologies

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 expand […]

NOTE: Using the ANY and ALL Operators in PROC SQL

Let me put my cards on the table before we start: I had never heard of the ANY and ALL operators in PROC SQL before I spotted David Shannon’s tweet this evening. The ANY and ALL operators are PROC SQL operators which can be used to compare the result o…

SAS Data Step Illustrated: Guest Blog by Jiangtang Hu

The following blog is reprinted by permission of the author Jiangtang Hu. Hu is a SAS programmer living in Beijing who writes blogs in both English and Chinese. (Full disclosure: Hu quoted The Little SAS Book, but I had never met him before he wrote this blog.) SAS Data Step’s Built-in Loop: An Illustrated Example […]

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 […]

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 […]

SGF: Caesars Palace in Las Vegas again

The mechanic, who wishes to do his work well, must first
sharpen his tools.
–Confucian Analects. BOOK XV.WEI LING KUNG.CHAP.IX.

My paper Work Smarter than Harder-tools for growing up a SAS programmer was accepted by SAS Global Forum 2011. It would be my first time to attend SAS user group conference worldwide. The draft version is […]

A SAS Programmer’s End Year Haiku

End year Haiku again!
Yesterday I finished my project, wrote a Haiku to colleagues worldwide to say happy new year, then closed my desktop, said goodbye to colleagues still in office:
In December my baby born
my project deliveries followed on
Now my co…