SQL Examples

Usually you want a quick easy response to the problem that you are searching for the solution to on the web, right?  Well here are two common reasons (with example code) why you may be receiving this error:

1.) On your join statement, your ON or AND statements are asking to join columns on a different table other than the two tables that you are originally intending to join.

Example:

If you are reading this it is because you have written a PROC SQL statement where you reference both a dataset that you created in an earlier step and a table that resides on an RDBMS (such as SQL Server, MySQL, Teradata, etc . .  .).

Well before you go any further I have to tell you that so far it is not possible to combine the results of a SAS data set and an DBMS table within one PROC-SQL-CREATE-TABLE-AS statement.

For example with the following code I would get an ODBC error saying that "object LIBRARY.SASDATASET1 is not an object in RDBMS ..."

The majority of tables that record transactional data contain many years of transactional data.  So if you wanted to compare sales in 2007 to sales and 2008, it may be a little tricky considering that the sales figure for any year are stored in the same column.

For example: