Creating new rows of observation from the new range of date

[OJohn_StaT]

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?

[Kurt_Bremser · Accepted solution]

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;

[OJohn_StaT]

Thank you so much for your time and your contribution!