Hi, I have a base table of  a million or above rows which has 4 variables as provided below. i wish to update the date and name column in the base table using the values provided in the small_table. The join is to be on the ID and the SUB_ID variables. My base table has a composite index defined on it hence i would require a update solution which would not delete the index. Could someone guide me in the correct direction. DATA BASE_TABLE; INFILE DATALINES DELIMITER = '|'; INPUT  ID1 : $10. SUB_ID : $10. NAME : $30. DATE : DATE9. DATALINES; AA|123|NAME1|01JAN2012 AA|134|NAME2|01JAN2012 AB|123|NAME3|01JAN2012 AA|145|NAME4|01JAN2012 ; RUN; DATA SMALL_TABLE; INPUT  ID1 : $10. SUB_ID : $10. NAME : $30. DATE : DATE9. DATALINES; AA|134|NAME6|01MAR2012 AB|123|NAME7|10MAR2012 ; RUN; ... View more

Hi, Could someone point me in the right direction for my below requirement.. I wish to take the sum of variables A: based on the values of the variables START and END. For Example for the first row in the below dataset the Start value is 1 and End Value is 5 hence the sum is to be calculated for the variables A1 to A5. Data Have; input START END A1 A2 A3 A4 A5; CARDS 1 5 1 2 3 4 5 1 3 1 2 3 4 5 2 4 1 2 3 4 5 ; RUN; The Final Column to be derived is 15 6 9 Thanks In advance ... View more