topic Re: PROC SQL run MS SQL 2005 stored procedures without MS SQL in SAS Procedures

PROC SQL run MS SQL 2005 stored procedures without MS SQL

Alan — Wed, 07 Dec 2011 17:17:04 GMT

Can SAS PROC SQL run Microsoft SQL 2005 stored procedures without relying on Microsoft SQL? The SAS SQL Pass-Through Facility requires a database with procedure objects in it and I assume an instance of MS SQL running.

Assuming no database objects existed in MS SQL 2005 or even if there was no instance of MS SQL Server, can SAS run SQL stored procedures?

It would need to use MS SQL commands like declare, fetch, exec, begin transation and others.

Before rewriting a SAS solution I wanted to check if we could just copy our stored procedures and run them as is.

Thanks

PROC SQL run MS SQL 2005 stored procedures without MS SQL

FriedEgg — Wed, 07 Dec 2011 17:27:51 GMT

No, SAS cannot interperet stored procedures written for Microsoft SQL Server natively. The pass through facility relys on the dbms existing and having the objects there.

Re: PROC SQL run MS SQL 2005 stored procedures without MS SQL

Reeza — Wed, 07 Dec 2011 17:47:01 GMT

No, but you should be able to call a stored procedure using the pass through facility and then read or import the results into SAS.

IMO SQL can do most things that SAS can do, unless you're doing statistical analysis, then SAS is the tool that you'd want.

Re: PROC SQL run MS SQL 2005 stored procedures without MS SQL

SASKiwi — Wed, 07 Dec 2011 19:48:25 GMT

Also there is no equivalent functionality in SAS SQL that is similar to the row by row control available in MS SQL stored procedures.

If you do not have Microsoft SQL Server, would I be correct in assuming you would be storing your data in SAS datasets anyway?

If this is the case then you could completey re-engineer what the MS SQL stored procedures are doing using the SAS DATA step to get the row by row control required.

PROC SQL run MS SQL 2005 stored procedures without MS SQL

Alan — Wed, 14 Dec 2011 13:53:34 GMT

Thanks for the replies everyone. So I'll start reengineering it in SAS. Thanks.