Executing SQL Server procs from SAS

[BenConner]

Good morning,

I assume the answer is 'no', but has anyone found a way to run a SQL Server proc from SAS? 

Thanks!

--Ben

[r_behata]

The Execute statement can be used to run the SQL Server Stored process from SAS.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473677.htm

[r_behata · Accepted solution]

here is the syntax :

PROC SQL;
	Connect to odbc (datasrc=datasrcnm user = user_id password = pwd);
		Execute(db.stored_proc) by odbc;
	Disconnect from odbc;
QUIT;

[BenConner]

Well isn't that slick.  🙂  And it even works with ODBC.

Thanks very much!

--Ben

[Reeza]

SQL Pass through - any code you pass over to the server will work, as long as you have the correct permissions.

[BenConner]

Someday I hope to convince them to get Access for SQL Server.  Until then... sigh.

--Ben