All, I am new to sas base environment. I am trying to update table data using input data. The table has primary key on 5 columns. out of 5 columns if 4 column values change then i need to update a date column. update &d_sybname..&d_tbl set A.end_date = %SYSFUNC(DATETIME())from &d_sybname..&d_tbl as A ,reflib.&dataset as B where A.bep_fisc_yr=B.bep_fisc_yr and A.bep_app_code=B.bep_app_code and A.bep_org_code=B.bep_org_code and A.bep_pgm_ele_code!=B.bep_pgm_ele_code and A.tran_pgm_ele_code=B.tran_pgm_ele_code; bep_fisc_yr,bep_app_code,bep_org_code,bep_pgm_ele_code,tran_pgm_ele_code are part of primary key. but whenever bep_pgm_ele_code value changes i need to update end_date column. sample: load1: bep_fisc_yr    bep_app_code   bep_org_code   bep_pgm_ele_code  tran_pgm_ele_code   end_date 2009               10                        45                      34                                   234                       null load2: bep_fisc_yr    bep_app_code   bep_org_code   bep_pgm_ele_code  tran_pgm_ele_code   end_date 2009               10                        45                      34                                   234                      current date 2009               10                        45                      23                                    234                       null load3: bep_fisc_yr    bep_app_code   bep_org_code   bep_pgm_ele_code  tran_pgm_ele_code   end_date 2009               10                        45                      34                                   234                     current date 2009               10                        45                      23                                   234                     current date 2009             10                        45                    13                                    234                    null i tried the above query, but the issue is my input dataset (reflib.&dataset) doesn't contain any headers. in this case how can i compare column values in where statement. Thanks, Madhu ... View more

All, I worked as Informatica developer and I am new to SAS base environment. in the existing code data is being inserted or updated using Modify statement and primary key( which is combination of 5 keys). col1,col2,col3,col4,col5 are part of primary key. col6 is date column. whenever new value comes in for col5 i need to update col6 of the previous record with current date. req : load#1: col1  col2  col3  col4  col5  col6 12      6        4     5       8      null load#2: col1  col2  col3  col4  col5  col6 12      6        4     5       8      current date 12      6        4     5       7       null load#3: col1  col2  col3  col4  col5  col6 12      6        4     5       8      current date 12      6        4     5       7       current date 12      6        4     5       6       null how can we implement above scenario using modify statement. Thanks, Madhu ... View more