Thank you so much Reeza. This was the answer I was looking for. I will read more about workterm now. ... View more

I have written a shell script and scheduled through cron jobs which will run at midnight to clean up the all the work tables which is 1 day old. So deleting them is not an issue. ... View more

Hello Jaap Thanks for the reply. I have started with the base SAS, and after getting a good understanding of sas coding, then only I jumped on to SAS DI, not before that. Yes I know to compress a physical table, or to set readbuf size or insertbuf and all the performance enhancing settings. But my question is very simple. If I run a job, or a code, SAS creates a work library which is session oriented and by default all the data sets which we create like Data temp ; Will be created and read as work .temp Now I know that when ever a session starts, autoexec.sas initializes the session and it creates a work library for us. This is done by workinit system option I guess. But I have gone through many documents, but none mention that how it is deleted if a session closed neatly and resides if it is not. I hope now I made my query clear. ... View more

Hello Linus, No there is no code running in a job which specify like delete work library or dataset=library kill; or something else. And yes by default if the job ended successfully then it will delete that work library, if aborted manually then it will not. ... View more

My question is very simple. How the work library which is created for our session gets deleted? Also if I terminate the job in between, why this work library folder resides on /temp and not get deleted. ... View more

? ... View more

That worked big time Jaap, thanks a lot and happy new year. ... View more

Thank you so much LinusH. I'll try this and share with you what happened. But I've a string feeling that this will work. ... View more

Ok. So it means to use any of the sql or Oracle or teradata functions, it needs to be first staged into its respective table and then we can use its respective functions. That makes sense. I had look into the code as well. Whenever I was using any of the expression inside table loader, it gets into the dataset I. E. Data null; Set W9fS0I; Where current_timestamp ; Run; Something like that. And I was thinking, how can a teradata function will be used in sas dataset. And if that so, why sas has provided it. Well thank you very much Patrick for the answer. I appreciate that. ... View more

Thank you Patrick for the kind reply. Can you please specify why is it necessary to first load the data into a staging area (teradata table)  to use teradata functions in the expression of table loader? Thanks ... View more

No answer yet? ... View more