Date:         Thu, 3 Sep 2009 16:06:59 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Pass Through from SAS to SQL Server
Comments: To: Doug <dleona1@state.wy.us>
In-Reply-To:  <200909032036.n83FeKSD020286@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

What are you currently doing?  Where are you failing?

In general, the way you use it is:

proc sql;
connect to oledb/odbc/etc. properties=(stuff);
select * from connection to oledb/odbc (stuff);
or
execute ( stuff ) by oledb;
quit;

Are you having trouble with the connect to oledb/odbc part?  Or is that
working fine, and you're having trouble with the use statements?

Post to the list some of your code [with username/password/ip marked out of
course] and we can be more helpful.

-Joe

On Thu, Sep 3, 2009 at 3:36 PM, Doug <dleona1@state.wy.us> wrote:

> I made several attempts at doing this but I cannot seem to make it work.
> Can someone with experience with the pass-through facility provide
> assistance? I use a desktop version of SAS 9.2.
>