Databases Reference
In-Depth Information
Specifying Options in the Code Generation Tab
In SAS Data Integration Studio 3.3, you can specify options on the Code Generation
tab in the general Options window. Use this method to affect the code that is generated
for all new jobs. Many of these settings are used for parallel processing and grid
computing.
To display the general Options window from the SAS Data Integration Studio
desktop, select Tools ￿ Options from the menu bar. For a description of the available
options, see the Help for the tab.
Adding SAS Code to the Pre and Post Processing Tab
You can add SAS code on the Pre and Post Processing tab in the properties
window for a job. To display the properties window for a job, right-click the icon for the
job in the Inventory tree and select Properties from the pop-up window. Use this
method to execute SAS code at the beginning or end of a job. For details about the
steps for adding code, see the Help for the tab. See also “(Optional) Reduce the Amount
of Data Processed by the Job” on page 153.
To redirect the SAS log and SAS output to specific locations, you could add this code
on the Pre and Post Processing tab:
PROC PRINTTO LOG=''
PRINT='';
RUN;
You can also specify option statements for options such as FULLSTIMER,
MSGLEVEL, SYMBOLGEN, UBUFNO, WORKTERM, BLKSIZE and BUFSIZE if you
want these options to apply to an entire job.
By default, SAS Data Integration Studio specifies the MPRINT option at the start of
the code that is generated for all jobs (before any pre-processing code). The MPRINT
option adds messages to the log that are useful for debugging in a development
environment. To turn off the default MPRINT option for a particular job, add the
following code to the Pre and Post Processing tab:
OPTIONS NOMPRINT;
See also “Redirecting SAS Data Integration Studio's Log to a File” on page 191.
Specifying Options for Transformations
You can specify SAS system options, SAS statement options, or
transformation-specific options on the Options tab or other tabs in the properties
window for many transformations. Use this method to take advantage of these options
when a particular transformation executes.
Follow these steps to display the properties window for a transformation in a job:
1 Open the job to display its process flow.
2 Right-click the transformation and select Properties from the pop-up menu.
For a description of the available options for a particular transformation, see the
Help for the Options tab or other tabs that enable you to specify options.
If the Options tab includes a system options field, you can specify options such as
UBUFNO for the current transformation. Some transformations enable you to specify
 
 
Search WWH ::




Custom Search