Posts Tagged ‘ Oracle ’

Jedi SAS Tricks: Some Experience Required

February 28, 2012
By

As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.”  I've always had difficulty solidly learning new programming techniques in a traditional class...
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

SAS, Oracle Weblogic, VMWare – Do not want to play nicely!

April 21, 2011
By

We have been looking to upgrade a client to SAS 9.2 and at the same time move to the clients corporate IT standard of virtualising the environments. The client has standardised on vSphere and I thought great SAS 9.2 supports vSphere (as much as the following SAS support page say’s SAS supports virtualisation) SAS® Product Support...
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

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

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.