Databases Reference
In-Depth Information
C:\>"C:\Program Files\SAS\SAS 9.1\sas.exe"
-work "C:\Documents and Settings\sasapb\My Documents\My SAS Files\My SAS Work Folder"
-noworkinit
-noworkterm
This redirects the generated Work files in the folder My SAS Work Folder.
To create a permanent SAS Work library in the z/OS environment, edit your JCL
statements and change the WORK DD statement to a permanent MVS data set. For
example:
//STEP1 EXEC SDSSAS9,REGION=50M
//* changing work lib definition to a permanent data set
//SDSSAS9.WORK DD DSN=userid.somethin.sasdata,DISP=OLD
//* other file defs
//INFILE DD ... .
CAUTION:
If you redirect Work files to a permanent library, you must manually delete these files to
avoid running out of disk space. ￿
Using a Transformation's Property Window to Redirect Output Files
The default name for a transformation's output table is a two-level name that
specifies the Work libref and a generated member name, such as work.W54KFYQY. The
Process tab in the property windows for some SAS Data Integration Studio
transformations has a Data Location button that enables you to specify the name and
location of the output table for that transformation. Note that this location can be a
SAS library or RDBMS library. This has the added benefit of providing users the ability
to specify which output tables they want to retain and allow the rest to be deleted by
default. Users can use this scheme as a methodology for checkpoints by writing specific
output tables to disk when needed.
Note: If you want to save a transformation output table to a library other than the
SAS User library, replace the default name for the output table with a two-level name. ￿
If you refer to an output table with a single-level name (for example, employee ),
instead of a two-level name (for example, work.employee ), SAS automatically sends the
output table into the User library, which defaults to the Work library. However, this
default behavior can be changed by any SAS user. Through the USER= system option,
a SAS user can redirect the User library to a different library. If the USER= system
option is set, single-level tables are stored in the User library, which has been
redirected to a different library, instead of to the Work library.
Adding a List Data Transformation to the Process Flow
In SAS Data Integration Studio, you can use the List Data transformation to print
the contents of an output table from the previous transformation in an process flow.
Add the List Data transformation after any transformation whose output table is of
interest to you.
The List Data transformation uses the PRINT procedure to produce output. Any
options associated with that procedure can be added from the Options tab in the
transformation's property window. By default, output goes to the Output tab in the
Process Designer window. Output can also be directed to an HTML file. For large data,
customize this transformation to print just a subset of the data. For details, see
“Limiting a Transformation's Input” on page 188.
 
Search WWH ::




Custom Search