Yes I think the SAS/Access OLEdb engine is licensed.. I think we use WinSQL though.. well the guys that use it.. I have mostly been workin on proc sql.

So can everything done in SQL (via WinSQL) be transferred to SAS? I am talking about the code here. Just the syntax!!

I think writing pass through queries is something i can no longer avoid.

Sigurd Hermansen <HERMANS1@WESTAT.com> wrote: Do you have the SAS/Access OLEdb engine licensed (assuming that your company is using MS SQL Servers)? If so, a SAS LIBNAME connection to OLEdb will extract data from MS SQL Server or operate on MS SQL Server tables. No need to learn another flavor of SQL unless you plan to write 'pass thru' queries or execute MS SQL Server 'pass-thru' queries. Same goes for Oracle or DB2 servers or others. S

-----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Syb it Sent: Thursday, October 25, 2007 1:48 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Proc SQL vs WinSQL

Dear All,

My company is changing things (got some really huge and neat servers, that now allow us to do data pulls that previously took hours in seconds). The code is mostly in SQL and i have been using mostly proc sql to run my queries.

My questions is this: How differently really is Proc SQL from programing in WInSQl for example? Is there a need on my part to invest in WinSQl if I wanted to do it on my own? Or could I just keep slogging it out in the SAS environment that I already have?

Advice would be appreciated.

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com