SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

how to delete a work dataset by using di studio 4.21

Reply
Frequent Contributor
Posts: 76

how to delete a work dataset by using di studio 4.21

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

Regards,

Bina

Respected Advisor
Posts: 3,893

how to delete a work dataset by using di studio 4.21

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.

Contributor
Posts: 63

Re: how to delete a work dataset by using di studio 4.21

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.         

Ask a Question
Discussion stats
  • 2 replies
  • 423 views
  • 0 likes
  • 3 in conversation