SAS Data Integration Studio P39:This manual is a companion to the online Help for SAS Data Integration Studio. The Help describes all windows in SAS Data Integration Studio, and it summarizes the main tasks that you can perform with the software. The Help includes examples for all source designer wizards, all target designer wizards, and all transformation templates in the Process Library tree. | Optimizing Process Flows A Minimizing Remote Data Access 185 do n 1 to num_members this_member scan work_members n call symput member trim left put n best. trim this_member end call symput num_members trim left put num_members best. run if _members gt 0 then do proc datasets library work nolist do n 1 to _members delete member n end quit end mend clear_work clear_work Note The previous macro deletes all data sets in the Work library. a For details about adding a post process to a SAS Data Integration Studio job see Adding SAS Code to the Pre and Post Processing Tab on page 225. Deleting Intermediate Files at the End of Processing The transformation output tables for an process flow remain until the SAS session that is associated with the flow is terminated. Analyze the process flow and determine whether there are output tables that are not being used especially if these tables are large . If so you can add transformations to the flow that will delete these output tables and free up valuable disk space and memory. For example you could add a generated transformation that would delete output tables at a certain point in the flow. For details about generated transformations see Adding a Generated Transformation to the Process Library on page 228. Minimizing Remote Data Access Avoid or minimize remote data access in a process flow. For more information about remote data access see Supporting Multi-Tier N-Tier Environments on page 64. 186 Setting Options for Table Loads A Chapter 11 Setting Options for Table Loads SAS Data Integration Studio provides several different transformations for loading output tables in a process flow as shown in the following table. Table Loader Transformations Table reads a source table and writes to a target table. This transformation is added Loader automatically to a process flow when a table is specified as a source or a target. SCD Type 2 loads source data into a dimension table detects changes between source and target Loader rows
