BookmarkSubscribeRSS Feed
L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

Hi,

 

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.

 

Thank you

Trix
10 REPLIES 10
LinusH
Tourmaline | Level 20

Actually, I don't think that feature is availble in SAS Studio ...(yet, I hope)

Data never sleeps
Cynthia_sas
SAS Super FREQ
Hi, well, you could, if you wanted to do all the typing yourself, create the stored process manually, but to register the stored process in the metadata, you'd have to use either Enterprise Guide or SAS Management Console and then to test the stored process, you'd need to use either Enterprise Guide or one of the SAS Platform client applications (like Word or PPT) or another app like Web Report Studio or the Information Delivery Portal.

There's not a Stored Process Wizard in SAS Studio, so right now, I don't thing that SAS Studio has anything to offer above and beyond what you can get from Notepad for typing code.

Supposedly, stored processes with SAS Studio are on the way or being considered, but I do not thin they are here yet.

cynthia
AmyP_sas
SAS Employee

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.

L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

Hi Amy,

 

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?

 

Thank you

Trix
AmyP_sas
SAS Employee

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).

L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

Thanks Amy. I have turned on the feature. i will test it on this weekend and will update you by Monday.

 

Thank you

Trix
L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

Hi Amy,

 

Is there any other experiemental feature available?

Trix
L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

Hi Amy,

 

Testing stored process:

 

i ran the sample stored process. i got the following errors:

 

Testing stored process in sas studio:

Findings:

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?

 

Thank  you

Trix
AmyP_sas
SAS Employee

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:

  • Macro Variable Properties – works
  • Multiple Output Formats – works
  • Frequency Analysis – works
  • Cholesterol by Sex and Age – works
  • Shoe Sales By Region – fails because replay is not supported. However if you remove the href references then the code works fine.
  • Year to date budget – fails because no access to preassigned library
  • Shoe Sales Graphics – fails, it doesn’t handle STREAMCONTENTS
  • Hello World – fails because it does not produce ODSDOC output. Editing the proc stp code to handle _webout allows this to work.
  • European Demographic Data – fails, no access to preassigned library
  • European Demographic Data Detail – fails, no access to preassigned library

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).

L_R
Fluorite | Level 6 L_R
Fluorite | Level 6

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.

 

Thank you

Trix

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 4043 views
  • 5 likes
  • 4 in conversation