https://communities.sas.com/t5/SAS-Programming/I-need-a-code-for-the-following-scenerio/m-p/18062#M2668 What if:<BR /> - you give us a working test dataset (valid input statement).<BR /> - you give us an example showing based on the testdata showing how the desired result should look like. Tue, 14 Apr 2009 09:50:31 GMT Patrick 2009-04-14T09:50:31Z https://communities.sas.com/t5/SAS-Programming/I-need-a-code-for-the-following-scenerio/m-p/18061#M2667 I need a code for the following scenerio<BR /> In a dataset I have columns like Acc_sk,Acc_ID, Coll_Status,Valid_from and Valid_to <BR /> <BR /> Dataset:Account<BR /> Acc_sk Acc_ID Coll_Status Valid_from Valid_to<BR /> 1 001 open 4-13-2009 12:00:09 PM 4-13-2009 23:00:09 PM<BR /> 2 001 closed 4-13-2009 12:00:10 PM 1-1-2010 23:00:09 PM<BR /> 3 001 open 1-1-2010 23:00:09PM 1-1-5999 00:00:00 <BR /> 4 002 open 4-13-2009 12:00:09 PM 4-13-2009 23:00:09 PM<BR /> 5 002 closed 4-13-2009 12:00:10 PM 1-1-5999 00:00:00 <BR /> I need to apply check in this table that wether the difference between valid_from of each Acc_ID where max(valid_to) and valid_to of its previus row should be of one sec.<BR /> Moreover I need to make it generic where the value of target table will be in a macro and also the value of columns(like Acc_ID) will also be stored in a macro as a comma separated list.(means it could be one column or combination of one or more columns) Tue, 14 Apr 2009 08:31:27 GMT https://communities.sas.com/t5/SAS-Programming/I-need-a-code-for-the-following-scenerio/m-p/18061#M2667 deleted_user 2009-04-14T08:31:27Z https://communities.sas.com/t5/SAS-Programming/I-need-a-code-for-the-following-scenerio/m-p/18062#M2668 What if:<BR /> - you give us a working test dataset (valid input statement).<BR /> - you give us an example showing based on the testdata showing how the desired result should look like. Tue, 14 Apr 2009 09:50:31 GMT https://communities.sas.com/t5/SAS-Programming/I-need-a-code-for-the-following-scenerio/m-p/18062#M2668 Patrick 2009-04-14T09:50:31Z