When a File or directory prompt is defined for a SAS^® Stored Process, the properties for this prompt type require that you select a SAS^® Workspace Server (for example, SASApp - Logical Workspace Server) as the SAS server to use for providing the prompt interface.

In some cases, the SAS server property is ignored and a SAS^® Pooled Workspace Server is used instead.

If you execute a stored process that uses the File or directory prompt type in a SAS desktop application such as SAS^® Enterprise Guide^®, the following rules apply:

• The SAS Workspace Server (for example, SASApp - Logical Workspace Server) that was selected as the SAS server is used for the File or directory prompt interface.
• The Browse button for the File or directory prompt honors the File Navigation setting specified in the metadata properties for the designated workspace server.
• The SAS Workspace Server is launched using the client logon credentials, and file-system permissions to access files and directories in the prompt are based on this user ID.

However, if a stored process that uses the File or directory prompt type is executed in a SAS web application such as the SAS^® Information Delivery Portal or the SAS^® Stored Process Web Application, then the following rules apply:

• The SAS server property in the prompt definition is ignored.
• A SAS Pooled Workspace Server (for example, SASApp - Logical Pooled Workspace Server) is used for the File or directory prompt interface.
• The Browse button for the File or directory prompt always displays the system-root directory on the application server machine instead of using the File Navigation setting in the metadata properties for the pooled workspace server.
• The SAS Pooled Workspace Server is launched using multi-user credentials (by default, the sassrv user account), and file-system permissions to access files and directories in the prompt are based on this user ID.

There is no way to force the web applications to use the selected SAS server when the Browse button is clicked in the File or directory prompt. 

You can clarify the file navigation behavior in web clients by using the Description field of the prompt to instruct users about how to navigate if they use the Browse button.

For example, you can add a prompt description similar to the following on the General tab of the properties for this prompt type:

Here is what the description text looks like in the client application:

You might be able to accomplish your goal by using the file upload capabilities of the SAS^® Stored Process Web Application. For details and examples, refer to the documentation on Uploading Files in the SAS(R) 9.4 Integration Technologies / SAS Stored Processes: Developer’s Guide.

Operating System and Release Information