Dear ALL,   How can I force a dbms run for an Extract Transofrmation ? I have the input table on Oracle, the result of the extract generated in a library of type Oracle. However the Extract seems not pushed on DBMS but rather run by SAS.   I have checked the Action - Check Database Processing and at the Details section it is written - Unable to completely process on Oracle.   At the Extract Transformation - Options - Additional Options - Use the optimized pass-through facility for SQL statements is set to Yes.   Any hints?   Thanks ... View more

Dear All,   How can I add another Tree within the Transformations Trees in SAS DI ?  Thus , beyond the default trees (Access, Analysis etc.) I want to have a new one , let's say, names Custom Transformations.   Is it possible to have it - maybe by using Management Console?   Thanks! ... View more

Dear all,   I have a simple basic code (from Sas Enterprise Guide 7.1) which connects to a server and copies a file from a shared path (between 2 servers) to a local path. part of the code :   %signon; rsubmit; /*F is the shared path, D is local*/ data _null_; x "cd F:\Folder"; x "copy aaa.csv D:\path\folder\aaa.csv"; run; endrsubmit; signoff; When checking the log, it states: NOTE: Remote submit to SERVER commencing. Critical error 1 data _null_; 2 x "cd F:\folder" 2 ! ; 3 x "copy aaa.csv D:\path\folder\aaa.csv" 3 ! ; 4 run; So no copy done.   it is strange that if we try to copy within the same partition it works. this code works: data _null_; x "cd D:\folder"; x "copy aaa.csv D:\path\folder\aaa.csv"; run; There is no case of non - existing files / paths. They do exist.   Any thoughts?   Thanks! ... View more

Hello Experts,   We have an error when we run a datastep with hash tables. The table we try to load in hash is very big and probably the error is caused by lack of enough memory. What bothers is that the same datastep ran successfully on another environment but we can not determine what settings stop the process of running successfully everywhere.   The error is:   The SAS task name is [DATASTEP] Segmentation Violation Traceback of the Exception: etc.   we use - SAS 9.3 on AIX ... View more