topic how to delete a work dataset by using di studio 4.21 in SAS Data Management

how to delete a work dataset by using di studio 4.21

Ashwini — Sun, 11 Mar 2012 12:20:23 GMT

Kindly let me know ways how to delete a work table through di studio 4.21.

Regards,

Bina

Patrick — Sun, 11 Mar 2012 14:01:18 GMT

proc delete data=work.<your table>;

quit;

Add this in pre- or post-code of the node where it should happen.

Alternatively you can also use Proc Datasets or a SQL drop table.

Not really sure why you need to delete a work table - unless it's so big that you're getting troubles with your workspace while the job is running.

Riteshdell — Tue, 25 Aug 2015 16:09:45 GMT

Give the below code in any transformation post code for which table you want to delete work table.

proc datasets lib=work nodetails nolist;

delete WXXXXX;

run;

cheers.