Insufficient authorization to access PIPE error in SAS EG

Issue:

When I tried to run SAS code in SAS Enterprise Guide it throws following errors:

ERROR: Insufficient authorization to access PIPE.

ERROR: Error in the FILENAME statement.

Screenshot of error:

Solution:

This error occurs when you try to run OS commands in SAS code. To run the OS commands in SAS code you need to enable XCMD option. You check it in SAS Management Console by following below steps.

1.  Open SMC -> Expand Servers -> Expand
2.   In SASApp , expand Logical Workspace Server -> right click on Workspace Server.
3. Click properties -> option tab -> advanced options -> launch properties.
4. Check whether Allow XCMD is checked.

The issue arises if the Allow XCMD is not checked.

In above image, Allow XCMD option is not checked. It should be checked to run OS commands from SAS code.

In Unix /Linux machines, this XCMD option can be enabled by using system option XCMD in sasv9 config file or workspaceserver.sh script file.

Use your preferred method to enable XCOMD and restart the object spawner.

If you like to make changes in config file, then move to Workspaceserver configuration directory and add this option sasv9 or Workspaceserver.

How to enable XCMD system option?

Using SMC:

Go to the Workspaceserver properties as I mentioned in above steps. Then check the Allow XCMD option and restart the object spawner for the changes to take effect.

Using sasv9 config file:

Use preferred editor to open sasv9 or sasv9 usermods config file. Then add –xcmd option. Below are the steps.

vi sasv9_usermods.cfg

Then add this system option

-xcmd

Using WorkspaceServer_usermods.sh

Open the WorkspaceServer_usermods.sh using your preferred editor. Then add the below line in the script

USERMODS_OPTIONS=" -xcmd "

There is space after and before double quotes.

Use any one of the above method. Make sure you add this option only once. If you do in SAS Management Console then it is not needed to make changes in Workspace or SASV9 config file. For any of the above methods, after the changes were made restart the Object Spawner.

Leave comments if you still get the “Insufficient authorization to access PIPE” error or any doubts in making changes in configuration file.