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
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
See also attached picture what it might look like
Bruno
Ashwini,
Refer the following link . Page 8 , Section:Deleting
http://support.sas.com/publishing/pubcat/chaps/59353.pdf
Hope that helps
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
See also attached picture what it might look like
Bruno
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.