topic Re: Creating new rows of observation from the new range of date in New SAS User

Creating new rows of observation from the new range of date

OJohn_StaT — Thu, 19 May 2022 11:54:52 GMT

This observation above is one of thousands of observations in my dataset. Member name JD25654 has a subscription between these dates. Using this data, I want to make a new dataset like the following dataset. Subscription dates of each member are changing. Some of them have been members for 10 years, some of them have been a member for 1 year. I tried ways like lagging etc, but I couldn't get this dataset I need. Could you help?

Re: Creating new rows of observation from the new range of date

Kurt_Bremser — Thu, 19 May 2022 12:38:44 GMT

Use a DO loop:

data want;
set have;
do year = year(subscription_start_date) to year(subscription_end_date);
  output;
end;
keep user_id year subscription;
run;

proc sort data=want;
by user_id descending year;
run;

Re: Creating new rows of observation from the new range of date

OJohn_StaT — Thu, 19 May 2022 12:47:54 GMT

Thank you so much for your time and your contribution!