topic Re: Expanding start and end dates in SAS Procedures

Expanding start and end dates

andp — Thu, 19 Jul 2012 18:58:26 GMT

Hello,

I'm currently trying to do what should be a simple task but the searches for proc expand and retain functions haven't been giving me the code that I need.

I currently have 3 columns, ID, Startdate, enddate, and I'd like to expand my dataset to fill in the months between my start and end dates.

For example:

ID Startdate Enddate

1 01/2001 03/2001

Would become:

ID date

1 01/2001

1 02/2001

1 03/2001

Thanks.

Re: Expanding start and end dates

tish — Thu, 19 Jul 2012 20:10:28 GMT

I assume that startdate and enddate are both SAS dates in mmyys7. format:

data new (keep=id date);

set old;

format date mmyys7.;

do increment = 0 to intck('month', startdate, enddate);

date = intnx('month', startdate, increment, 'beginning');

output;

end;

run;

Re: Expanding start and end dates

andp — Thu, 19 Jul 2012 20:18:31 GMT

Works exactly as I wanted! Thanks!