topic Re: Executing SQL Server procs from SAS in SAS Programming

Executing SQL Server procs from SAS

BenConner — Fri, 30 Nov 2018 16:00:43 GMT

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 — Fri, 30 Nov 2018 16:09:53 GMT

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

r_behata — Fri, 30 Nov 2018 16:13:48 GMT

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;

Reeza — Fri, 30 Nov 2018 16:15:16 GMT

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

BenConner — Fri, 30 Nov 2018 17:57:09 GMT

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

Thanks very much!

--Ben

BenConner — Fri, 30 Nov 2018 17:58:12 GMT

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

--Ben