@mansour_ibrahim - you can use the `SYSPROCESSMODE` macro variable. More info here: https://stackoverflow.com/questions/48464813/determining-server-context-workspace-server-vs-stored-process-server
... View more
These statistics transformations must have been added to DI Studio by mistake. What do you want to do? You are probably better off using GROUP BY in Extract or Join transformations.
... View more
I found out that this is really what i want and working: proc sql; DELETE FROM &_input2. as b WHERE EXISTS(SELECT 1 FROM &_input1. as a WHERE a.variable1=b.variable1 and a.variable2=b.variable2); quit;
... View more