09-21-2016 04:24 PM
I am trying to create a stored process from sas studio. But i do not see any option to create a stored process. Could someone help me with this.
09-21-2016 08:48 PM
09-22-2016 07:55 AM
As the others have said, there's no stored process creation mechanism in SAS Studio beyond your abillity to get your SAS code tested - registration in metadata has to be done elsewhere. What we've been focusing on is integrating stored processes & Studio tasks since the functionality is similiar.
There is hidden experimental functionality starting in SAS Studio 3.3 which allows users of the enterprise edition to access their stored processes in a SAS Folders tree in Studio and run them as tasks. To enable this functionality, the administrator must alter the config properties file to turn on experimental features (webdms.showExperimentalFeatures=true) then the user can go to Preferences -> Tasks and turn it on by checking "Enable Stored Process Adapter (Experimental)." This preference does not appear if the config file has not been altered. Once enabled, you can drag a stored process from the SAS Folders tree and it will open as a SAS Studio task. The code generated by the task uses PROC STP to run the stored process. Not all types of stored process prompts are supported. The main important omissions right now are dynamic prompts & date handlers.
The Studio and stored process R&D teams are looking for feedback on this feature in general and specifically on what important prompt types are still missing. So if you have a chance to give it a try, please let us know your thoughts.
09-22-2016 09:46 AM
Thanks for the information. I would like to try out this. Where is the config property file located and what is the name of the file?
09-22-2016 10:02 AM
Take a look at the admin guide - http://support.sas.com/documentation/cdl/en/webeditorag/69506/HTML/default/viewer.htm#p0fecekwkd0dx3... - that should help you find what you need (and you might have to ask the person who did the installation if it wasn't something you were involved with).
10-03-2016 11:11 PM
Testing stored process:
i ran the sample stored process. i got the following errors:
Testing stored process in sas studio:
Not able to edit the code or save it
The sample stored process was run and received the following errors
WARNING: Remote execution of a SAS 9.2 stored process is not supported.
NOTE: The stored process will execute locally.
NOTE: PROC_STP: ====== Proc STP Execution Starting ======
NOTE: PROC_STP: ====== Stored Process: /Products/SAS Intelligence Platform/Samples/Sample: Shoe Sales by Region ======
65 + if first.region then rnumber + 1; 66 + 67 + file = "region" || trim(left(put(rnumber, 4.0))) || ".html"; 68 + 69 + href = 'href="' || &_replay || trim(file) || '"'; 69 + href = 'href="' || &_replay || trim(file) || '"'; -- 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. WARNING: The data set WORK.SHOES may be incomplete. When this step was stopped there were 0 observations and 10 variables. WARNING: RUN statement ignored due to previous errors. Submit QUIT; to terminate the procedure. 112 +%STPBEGIN; 112 body=region1.html newfile=table ---- ------- 22 22 ---- 202 ERROR 22-322: Syntax error, expecting one of the following: ;, CAT, CATALOG, CLOSE, DIR, NAME. ERROR 202-322: The option or parameter is not recognized and will be ignored. 112 body=region1.html newfile=table ------- 76 ERROR 76-322: Syntax error, statement will be ignored.
What all the things have to be changed or takend into consideration before running the stored process in sas studio?
10-04-2016 01:39 PM
Thanks for giving it a try & sorry for the bad first experience. Studio makes use of PROC STP to run the stored process so when you have a stored process that has syntax PROC STP can't handle, it will fail. Some of the sample stored processes have syntax in the SAS code that was written for the stored process server instead - for example, some samples were written to be output to a browser or have hooks that are recognized by the STP Web App and other clients. The PROC STP environment doesn’t know about those hooks and so the stored process will fail. Here's a list the stored process testing folks made of the common samples and their status:
If you're game to keep trying, we're still looking for what functionality you commonly use in stored processes that you'd want to see working in Studio. We won't be able to completely recreate this wheel, but we want to get in as much commonly used functionality as we can before this can be marked production.
And to answser your earlier question, there's no other experimental functionality hiding out there (so far).
10-04-2016 02:20 PM
Thank you Amy for the detail explanation.
We are mainly looking to create REST webservices using SAS Studio. Hoping for the feature to be available soon
Will keep you posted on how our experiment goes.