Yups, Its an update to accomplish Incremental loading. But Unique key "Name" has multiple entries based on financial year, amout...etc.    Scenarios is like,    Main_Table Year        Name        Amount 2019 ABCDS6008K 500   INC_Table Year      Name          Amount 2019 ABCDS6008K  500 2020 ABCDS6008K 1000       ... View more

Hi Kurt, Thanks for your kind support.   I have to perform two steps:   1st Step: Delete records from Main_Table which is on LASR server and contains data for a BI report. Here records which need to be deleted must be identified from INC_Table through column "name".  Challenge:  1.Macro variable "KeyName" performing perfect for small size INC_Table but failing large INC_Table and giving error of limited length characters. 2. Sub queries do not work with where clause under PROC IMSTAT Procedure.   Proc sql noprint; select distinct compress("'"||NAME||"'") into: KeyName separated by  ',' from VALIBLA.INC_TABLE; quit; proc imstat; table VALIBLA.MAIN_TABLE; where NAME in (&KeyName); deleterows/purge; run;     2nd Step:  Append records in Main_Table from INC_Table (Its simple by below step and no challenges in it).   proc imstat; table MAIN_TABLE; set INC_TABLE/drop; run; ... View more

Thanks Nihanta, KurtBremser, Tom, Smantha.   Appreciate your kind help.  My requirement is to Delete rows from Main_Table which are identified in INC_Table through column "Name" As Main_Table is on LASR server, need to perform this task using PROC IMSTAT. And after which I have to append all records from INC_Table to Main_Table (Which is simple to do so).   Please suggest the way out: 1. If I can get alternate of macro variable where length limit is exceeded.  2. Also please suggest how same can be used  in where clause under PROC IMSTAT. (how view is used if created) As syntax error blocks the task further.    Thanks & Regards, Robin Sharma     ... View more