The following
line of code specifies the default value for the "SAS Parameters"
property.
obConnection.Properties("SAS Parameters") = "-initstmt %sasodbc(sdplserv) -icon -nosplash"
The initialization
statement
-initstmt
executes a SAS macro
named
%sasodbc
, which in turn invokes the
server identified by
sdplserv
. The
-icon
option immediately minimizes the SAS session.
The
-nosplash
option suppresses the SAS logo
and copyright information.
The %sasodbc
macro ships with Base SAS and is found in
!sasroot\core\sasmacro\sasodbc.sas
. This macro,
which was created for use with the SAS ODBC driver, executes PROC
ODBCSERV. To specify PROC ODBCSERV options in addition to the
sdplserv
server ID, you can modify the sasodbc.sas file.
You can also modify sasodbc.sas in order to include additional SAS
system options or SAS statements such as the LIBNAME statement.
CAUTION:
If you also use the SAS ODBC Driver, you should create
a separate SAS macro file for use with the Base SAS provider.
Note: The PROC ODBCSERV
options are identical to the PROC SERVER statement options. For more
information about the options, see the
SAS/SHARE User's
Guide.
Note: !SASROOT is
the logical name for the directory in which you install SAS.