oscar's blog

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: