|
Hello:
The data I have:
data have;
informat from_date to_date mmddyy10.;
input from_date to_date;
cards;
01/01/2003 03/06/2003
05/03/2004 05/28/2004
12/07/2005 02/03/2006
04/04/2006 05/31/2006
;
The output I needed:
01/01/2003 01/31/2003
01/31/2003 02/28/2003
02/28/2003 03/06/2003
05/03/2005 05/28/2004
12/07/2005 12/31/2005
12/31/2005 01/31/2006
01/31/2006 02/03/2006
04/04/2006 04/30/2006
04/30/2006 05/31/2006
the rule is if the inverval between from_date and to_date is serveral
months, then the obs will be expanded to serveral obs.
thank you for the help,
baogong
| 
