Hi All, as update is too slow in SAS Proc SQL we found a faster way to update big tables in a very fast way using hash and database views it's known that: 1- if you update in database view you will update the physical table 2- hash update uses the memory (RAM) which might be slower if tables are very big. our solution is based on creating a view for all condition you want in the update statement in the view like simple solution: PROC SQL; UPDATE TABLE_A SET COLUMN_1 = {VALUE} WHERE condition_1 , condition_2 ;QUIT; our solution create view as select column_1 from table_a where condition_1, condition_2 then use the simple hash update which uses less memory ,faster update happy faster hash update Abdelrahman Mahareek AML Technical Consultant
... View more
