The following is an example of using PROC SQL Pass-through statements
with SAS/ACCESS Interface to ODBC to execute a stored procedure and
return an integer as an output parameter to SAS.  It uses a temporary
table to store the value from the output parameter:

  proc sql;
  connect TO ODBC (dsn=mydsn uid=myuid pwd=mypwd);
  execute (declare @vCount int exec myproc 4, @vCount Output create
    table #mytemp(col1 int) insert into #mytemp values (@vCount)) by
    ODBC;
  select col1 into : mID from connection to ODBC(select * from #mytemp);
  quit;

This is an example of reading data.  To update a temp table, you would
need to install a hotfix and use the CONNECTION=GLOBAL or
CONNECTION=SHARED option to accomplish this (see SAS Note  #006323 ).

There is a CONNECTION=SHARED_READ option (default) that is only used for
reading and not writing/updating data, so development provided a hotfix
to support the CONNECTION=GLOBAL and CONNECTION=SHARED option.

Example:
  libname myodbc odbc dsn=sqlserver2000 uid=dbitest pwd=dbigrp1
    connection=global;
  proc sql;
  create table myodbc.'#tmp'n as select * from sashelp.class;
  select * from myodbc.'#tmp'n;
  quit;

Without the hotfix, the CONNECTION=GLOBAL or CONNECTION=SHARED option is
invalid.  You must have this option or the libname works as follows:

  proc sql;
  create table myodbc.'#tmp'n as select * from sashelp.class;

In this example, the connection is made to the dbms, the table is
created and a disconnect from the dbms occurs.  At this point, the
table, #tmp, is gone.

Hot fixes for Release 8.2 are available.

V8.2 SAS/ACCESS to ODBC :
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02

Operating System and Release Information