BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I recently finished creating a stored process that runs well in Enterprise Guide, but does not run in Web Repport Studio. Has anyone else encountered this problem? If you did, what did you do to resolve it?

Thanks so much, in advance!
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
In order for Stored Processes to execute from Web Report Studio, they must be stored in a special location in the metadata known as the "BIP Tree" folder.

Looking at the SAS Log might help, if you are getting a SAS Log. If you are not getting a SAS Log, but are getting Java error messages, then you might consult the Platform Administrator documentation for help. Otherwise, there are other possibilities that might be involved, but your best bet for a quick response to this issue is to contact Tech Support.

cynthia
deleted_user
Not applicable
Hi, Cynthia,

What had happended was that I had an extraneous quit; at the end of my code, right before my %stpend; line. When I removed the quit; statement, my stored process worked correctly. I had already placed my process into the "BIP Tree" folder.

Thans for replying! I appreciate it.
deleted_user
Not applicable
I need to clarify this for myself Cynthia.

Have you any idea why an extra Quit; statement would cause this problem? From a foundation SAS viewpoint, an extra run, quit or semicolon is usually benign.

Why would this cause a problem for a stored process?

Kind regards

David
Cynthia_sas
SAS Super FREQ
David:
Without actually seeing ALL the code and the WRS log where it did NOT work, I'm not sure what was going on. SAS Web Report Studio uses SASReport XML by default. EG uses HTML by default as the result type. Removing an extra quit doesn't seem like it would have an effect for either result type creation -- UNLESS it was enclosed somehow in a nested macro call and abnormally ended -- a situation which EG might recover from more gracefully than WRS.

This is one reason why I recommend having a working SAS program to start (which only would have had 1 quit in the right place) and then when the code was "macro-ized" there would have been less of a chance to introduce an error.

cynthia

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 4 replies
  • 729 views
  • 0 likes
  • 2 in conversation