Managing Workspace Servers and Stored Process Servers

Changing SAS Options with the Stored Process Server

Overview of Changing SAS Options with the Stored Process Server

By default, the stored process server explicitly sets the following SAS options for each execution of a stored process:

NOSOURCE          Do not write SAS source statements to the SAS log
SOURCE2           Write secondary source statements from included files 
                  to log
                                 
CENTER            Center SAS procedure output
NODATE            Do not print date and time on top of each page of 
                  SAS log and procedure output

NONUMBER          Do not print page number on each page of SAS output
LINESIZE=195      Line size to 195 for SAS log and SAS procedure output

FORMCHAR=|----|+|---+=|-/\\<>*
                  Default output formatting characters for print device

PAGESIZE=40       40 lines printed per page of output
NOOVP             Do not allow output lines to be overprinted
NOMPRINT          Do not display SAS statements generated by macro 
                  execution
NOMLOGIC          Do not trace macro execution
NOSYMBOLGEN       Do not write results of resolving macro variable
                  references to SAS log

TITLE;            Clear titles
FOOTNOTE;         Clear footnotes

In SAS 9.2, the stored process server can be configured to run SAS code to override or change the value of the default SAS options before the execution of the requested stored process. This is a server-wide setting and will run before each execution.

Change SAS Options with the Stored Process Server

To change SAS options with the stored process server, follow these steps:

Write a simple stored process that sets SAS options and place the stored process in a directory where the stored process server can read it.

Here is simple example that uses SAS code to set line size to 150 and page size to 30:
```
options ls=150 pagesize=30;
```
In SAS Management Console, expand the Server Manager node, then right-click the icon for the SASApp - Logical Stored Process Server node and select Properties from the pop-up menu.
In the Logical Stored Process Server dialog box, select the Options tab, and then click Set Server Properties.
In the Stored Process Server Properties dialog box, select the Request tab.
In the Initialization program text box, type the path and filename that contains your SAS options code.

For example:
```
C:\myOptions\setoptions.sas
```
Click OK in the Stored Process Server Properties dialog box, and then click OK in the Logical Stored Process Server Properties dialog box.

Now, the stored process server will run your option override code before each requested stored process.

Top of Page