About pokerpercal

pokerpercal · ‎11-07-2018

That worked, I had messed up a variable in the loop which was causing the code to run indefinitely. Fixed that and formatted the month field. Thanks!

pokerpercal · ‎11-06-2018

I used the follow code: data want_month; set spanMOC; date=dateeff; do while (date<=dateterm); output; date=intnx('month', date, 1, 's'); end; run; This code will create the 7 rows I am looking for, the problem is that I cant figure out the concise way to create the new column that gives the month and in the format I described in the original post.

pokerpercal · ‎11-06-2018

Right now I have a list of subscribers to a product. Each subscriber has two fields indicating an effective and term date (named date_eff and date_term), such as 01JUL2003 and 31JAN2004. I would like to create a variable that is Month_Paid for each month in that range, so instead of having one row for that subscriber, I would now have 7 rows with the Month_Paid field being 01JUL2003, 01AUG2003, …, 01DEC2003, 01JAN2004. I've tried a few do loops that I read about on the forum but can't seem to find the correct logic. Thanks!

Online Status	Offline
Date Last Visited	‎11-07-2018 01:33 PM

Re: Need to create multiple rows from one based on a start and end dat...

Re: Need to create multiple rows from one based on a start and end dat...

Need to create multiple rows from one based on a start and end date.

Re: Need to create multiple rows from one based on a start and end dat...

Re: Need to create multiple rows from one based on a start and end dat...

Need to create multiple rows from one based on a start and end date.