The major problem seems to be: how will you distribute the rest of the data to your new periods? Repeat it? Divide it? The other thing? Something like that should do nearly what you want:

data test; start="01jan33"d; end="15mar55"d; output; start="03feb2000"d; end="15oct2003"d; output; format start end mmddyy8.; run;

data new; set test; do while (start<end); output; start=intnx("month",start,1); end; run;

On Tue, 23 Sep 2003 07:40:06 -0700, jcern <jcern15@YAHOO.COM> wrote:

>I am having trouble with date conversions for a particular function. >I have to change a single date period to multiple records of months >and years. For example, I have to change a date period of let's say, >1/1/00-3/15/01 to multiple records of: 1/00, 2/00,3/00,4/00 up until >3/01. In other words, I need the date period broken down into >month/year dates for each month and year of the time period. I >realize this is going to result in MANY records, but that is how I >have to format this, unfortunately. > >Does anyone have any idea how to go about doing this? > >Thanks!