Databases Reference
In-Depth Information
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.
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.
Search WWH ::
Custom Search