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
... View more