https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497361#M131802 Your only chance is to do it in an EXECUTE block using an explicit SQL pass through connection. No idea if this connection support this though. Thu, 20 Sep 2018 13:37:38 GMT LinusH 2018-09-20T13:37:38Z https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497349#M131795 <P>Hi All,</P><P>&nbsp;</P><P>Can anyone tell me how to create a SQL Server stored procedure in SAS?</P><P>&nbsp;</P><P>I've got some examples on how to execute the procedures. But I need to know how stored procedures can be created in SAS.</P><P>&nbsp;</P><P>Thanks,</P><P>Sampath</P> Thu, 20 Sep 2018 13:11:19 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497349#M131795 bmsampath 2018-09-20T13:11:19Z https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497355#M131798 <P>You create SQL Server Stored processes using SQL Server.&nbsp; SAS is not SQL Server.&nbsp; All SAS provides is the functionality to send SQL code through to the database for parsing and get results back.</P> Thu, 20 Sep 2018 13:27:33 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497355#M131798 RW9 2018-09-20T13:27:33Z https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497361#M131802 Your only chance is to do it in an EXECUTE block using an explicit SQL pass through connection. No idea if this connection support this though. Thu, 20 Sep 2018 13:37:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-create-a-SQL-Server-procedure-in-SAS/m-p/497361#M131802 LinusH 2018-09-20T13:37:38Z