getting error when I want to run a stored process in enterprise guide

Reply
Contributor
Posts: 36

getting error when I want to run a stored process in enterprise guide

ERROR: Insufficient authorization to access /opt/sas94/sasconfig/Lev1/SASApp/_webout.dat.

 

I would really be appriciated if someone helps me

Super User
Posts: 4,013

Re: getting error when I want to run a stored process in enterprise guide

It looks like your stored process web output destination is defaulting to a SAS installation configuration folder which typically read-only for most SAS users.

 

Often this destination is defined in a FILENAME statement like: filename _webout "Your webout folder";

 

Try a FILENAME statement in EG pointing to a server-based folder you have write access to.

Super User
Posts: 10,530

Re: getting error when I want to run a stored process in enterprise guide

[ Edited ]

_webout is a fileref that is automatically defined when a stored process is configured for stream output and run within a suitable context (usually via /SASStoredProcess from the web application server)

If you want to assign it a suitable filename when run from SAS code, look here how it is done:

STP Procedure - Outputfile Statement

 

Edit: if you already declared that file reference, you missed the fact that you have to use an "absolute" pathname in UNIX.

Absolute pathnames start from the root directory (therefore they start with a forward slash / ); names that do not start with a slash are considered relative to the current workling directory, which is in the SAS configuration tree for Workspace and Stored Process servers. You must not have write permission there, which is the reason for your ERROR.

If your stored process is run from the STP server, you must write your file to a location where the system's userid sassrv has write permission; if your STP is executed on a Workspace server, using $HOME/filename is sufficient, as the Workspace server runs under your own UID.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 58

Re: getting error when I want to run a stored process in enterprise guide

I recently had an issue as the STP I was testing was writing to a pdf destination.  As per this stackoverflow question (credit: DomPazz) I think there is now a solid answer to your conundrum.

 

Simply test to see if you are in an STP session, and if not, write to the cache!  

 

%if  not (%symexist(_metaperson)) %then %do;

  /* not an STP so redirect _webout */
  filename _webout cache;

%end;
/Allan
Think you know SAS? Take the sasensei challenge..
Ask a Question
Discussion stats
  • 3 replies
  • 542 views
  • 0 likes
  • 4 in conversation