Or, can I create another two macros, to replace these two statments wtih blank so that I need not open each one, cross out, or delete?     ... View more

Thank you. Before I do this, my understanding is, I should either cross out the original paths or replace with blank, as you suggest on your first post. Do I understand correctly?   ... View more

Sorry if I had not made it clear. I was replying to your post. Would you please share you code? I believe it would be easier.Thanks ... View more

That is what I am thinking but I do not know how to write the code.. Can you provide code? Thanks. ... View more

That is a good idea. I will try. ... View more

Thanks. I did try your code, and I deleted all records after the first record for the same patient. I do not know where the problem is and how to fix, I still want to keep later records, which are after 7 days ... View more

Thank you and I am sorry I have not made it clear.   when the bill date difference is within 7 days, even it has three or records, I want to consider it as one visit only, there fore, I only want to keep the first day record, and delete all other billing records, which are after the first record, but not later than 7 days, I need to create a variable, timelapase=time2-time1, and if timelapse > 0 but <=7, then all those later records will be deleted, only the first record will be kept here, the record with 78.91  will be recorded i sort it by id, date, and icd then if first.id=1 and first.date=1 and first.icd=1, then timelaspse=0, time=date; else timelapse=date(the next record)-time,, or date3(the records after that)=date-time   but I do not know how to do that ... View more

 I ran it, i still have same day records   please see table below, here only patient id 4, these two records are what i need, because these two visists are on two different dates, for id2  , because they have same icd code, same date, same patient id, i need to remove   by looking at the data, i notice, i also need to remove id 3, the billing date is 2 day difference, id5, one day difference, it might still be about the same visit, this is NOT i am interested in, so i need to remove those records with same id, same icd, same date or two billing date difference less than one week   thanks. id icd freq amount billingdate 2 v234 2 78.91 1/1/2015 2 v234 2 96.05 1/1/2015 3 v44 2 43.74 2/3/2015 3 v44 2 22.04 2/5/2015 4 e34 2 52.26 3/6/2015 4 e34 2 11.27 9/5/2015 5 j23 2 379.08 4/1/2015 5 j23 2 217.12 4/2/2015 ... View more