how to delete a table in work

Ashwini — Tue, 29 Nov 2011 05:21:21 GMT

Kindly explain me how to delete a table from the work through di studio if it is generated from the di studio transformation.

Thanks,

Regards,

Ashwini

how to delete a table in work

Amruta — Tue, 13 Mar 2012 14:09:22 GMT

Ashwini,

Refer the following link . Page 8 , Section:Deleting

http://support.sas.com/publishing/pubcat/chaps/59353.pdf

Hope that helps

Re: how to delete a table in work

BrunoMueller — Fri, 03 Aug 2012 12:09:07 GMT

Hi Ashwini

In general the intermediate result tables/views are automatically deleted at the end of a job, since they are in the WORK library.

If you want to delete them earlier you could add a User Written transformation and add your own code to delete the tables/views. You can simply connect the result tables/views from transformation to your User Written transformation. The code below will delete all the tables which are connected to the User Written transformation. Please be careful about when to run this transformation, as it might delete tables/views which are needed in subsequent transformations

%macro myDelete; 
  %local i;

  proc sql;
    %do i = 1 %to &_INPUT_count;
      %if &&_input&i._memtype = DATA %then %do; 
        drop table &&_input&i;
      %end; 

      %if &&_input&i._memtype = VIEW %then %do; 
        drop view &&_input&i;
      %end; 
    %end; 
  quit;

%mend; 

%myDelete

See also attached picture what it might look like

Bruno

topic how to delete a table in work in SAS Data Science

how to delete a table in work

how to delete a table in work

Re: how to delete a table in work