Add some diagnostic messages to your code so you can see its progress in the log. A real time of 12 minutes while only 1 CPU second is used points to very long wait times for the "disk" operation(s) occurring over a network mount. ... View more

SAS does exactly what you tell it to do, and it does not do things that you explicitly exclude: 5 /* filename tmpf "\\quintiles.net\enterprise\Apps\sasdata\StatOpB\TestingProcHadoop\Purna\DMPrograms\tempfile.txt"; */ 6 7 8 filename tmpf temp; The first FILENAME statement is commented out, so only the temporary file is created, with no content. Un-comment the first statement and remove the second. ... View more

OK, good. Please mark post as answered then. ... View more

In addition to Kurt's comments, you may be creating a number of intermediate files that are no longer needed, but are still taking up space on the disk.  Critically look at your code and perhaps add some clean-up steps. ... View more

That suggests that the connection definition in odbc.ini isn't the same as in your LIBNAME statement. Have you compared them? ... View more