how to delete a work dataset by using di studio 4.21

[Ashwini]

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

Regards,

Bina

[Patrick]

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]

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.