• Print |
• E-mail  |
• Bookmark

The following SELECT statement worked when using PROC SQL PASS-THROUGH
at SAS Version 6.12, but fails at SAS V8:

   select cd_st, name_st,
   into #mytemp
   from cd_st
   where date_updt='10/12/99'

This SQL extracts data in Sybase and inserts it into a temporary table
on the Sybase server without returning any results to the SAS program.
Beginning with Version 8, this syntax no longer worked.  Instead,
you must explicitly create the temporary table, including the column
definitions, then run the rest of the SQL in standard form.

This is a SAS Version 8 bug with the "select... into..." statement.
The problem is not that a temporary table is being created; the problem
is that "select ... into..." should work.  What is happening is that in
V6, in a PROC SQL EXECUTE statement, any "select" would return an error,
except if it was a "select... into..." type.

To resolve this problem, upgrade to SAS V8.2.

Operating System and Release Information