If so can I ask for a little help please. I have bitten off more than I can chew…SAS programming (well all programming) is a little alien to me, I have got my head round the SQL part of it but I don’t think SQL is appropriate for the next bit. What I want to do isn’t difficult, I have managed it in VBA, unfortunately I have no idea where to start in SAS. Any tips or pointers greatly appreciated.
I have a list of dates for a particular groups, so A could have 4 dates, B 10, C 1 etc. I want to look at a date, compare it to the record (row) previous and if the year is not consecutive then add in as many years to make it consecutive. eg. 23/06/2001, 04/12/2005 (2 rows) I would want to become 23/06/2001, 01/01/2002, 01/01/2003, 01/01/2004, 04/12/2005 (the program inserts 3 new rows). This would be done for each group only, so comparisons between last row of A and first of B are not made.
Apologies for asking here first, I could try a programmers forum but they are scarier than this place!