Here is my use case: From Pega BPM 7.x I only have ability to talk SQL using SAS JDBC. There is a program in SAS that is needed for my business process. 1. Load data into a SAS dataset (Read documentation, so assumed this will work http://documentation.sas.com/?docsetId=jdbcref&docsetTarget=p1pbz82pw98h7rn14cn3o0dhfo78.htm&docsetVersion=9.4&locale=en) This is done using standard INSERT/UPDATE SQL statements 2. Retrieve data from a SAS dataset (Tested, works as expected) This is done using standard SELECT SQL statements 3. Once data is loaded in the SAS dataset, I need to tell SAS to invoke a program to compute. (I don't know how to do this without having the ability to issue a CALL statement from within JDBC/SQL). Please provide some ideas on how to accomplish invoking of a SAS stored process from outside of SAS.
... View more
