Maintaining Environments

SAS Startup Files and SAS/Warehouse Administrator

When you install SAS software and SAS/Warehouse Administrator, the installation process creates a SAS configuration file (such as sasv8.cfg) that includes the appropriate SASHELP catalogs into the concatenated SASHELP library.

Be sure to specify the appropriate SAS configuration file in your SAS start command so that the SAS/Warehouse Administrator SASHELP catalogs will be visible in the underlying SAS session.

You might want to specify SAS options in the configuration file that would be useful in a SAS/Warehouse Administrator session. For details about such options, see SAS System Options and SAS/Warehouse Administrator.

SAS Autoexec File

A SAS autoexec file can include LIBNAME statements, SAS options, and various commands that are appropriate for the tasks you want to perform in SAS/Warehouse Administrator. For example, here is a typical SAS autoexec file for SAS running under Microsoft Windows or Windows NT:

/* Typical SAS autoexec for SAS/Warehouse Administrator */

/* Assign getusrpw catalog. Provides access */ 
/* to GETUSRPW macro required by some */
/* SAS/CONNECT scripts. */ 
filename getusrpw catalog 'sashelp.dwport'; 
options sasautos=(getusrpw sasautos);  

/* Assign _saswa lib. Provides access */
/* to SAS/Warehouse Administrator add-ins */
/* and other software. */  
libname _saswa 'd:\username\dw\sample8';

/* Start SAS/Warehouse Administrator */
dm "dw" continue;

GETUSRPW support is often enabled on the host where SAS/Warehouse Administrator is installed. However, the getusrpw catalog is not needed until you are ready to create and test remote host definitions.

Most sites will want to install and use at least some of the add-in software available for SAS/Warehouse Administrator. However, the _saswa library is not needed until you have installed some of these add-ins. In the libname _saswa statement above, you could replace username with any convenient directory name.

You might want to have your SAS autoexec file start SAS/Warehouse Administrator, as shown in the previous example (see the dm "dw" continue; command).

You might want to add a command to your SAS autoexec file that will set the start directory for the SAS session. Here is an example of such a command:

x 'cd c:\username\dw'

This is important if the Warehouse Environment in which you will be working uses relative pathnames.

You also might want to specify SAS options in the autoexec file that would be useful in a SAS/Warehouse Administrator session. For details about such options, see SAS System Options and SAS/Warehouse Administrator.

Top of Page