Good morning,
I assume the answer is 'no', but has anyone found a way to run a SQL Server proc from SAS?
Thanks!
--Ben
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;
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
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;
Well isn't that slick. 🙂 And it even works with ODBC.
Thanks very much!
--Ben
Someday I hope to convince them to get Access for SQL Server. Until then... sigh.
--Ben
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.