https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876720#M346346 <P>&nbsp;</P> <P>If your start and end year values are numeric this should work.</P> <PRE>data want; set have; do YearsActive = StartYear to Endyear; output; end; keep groupid memberid yearsactive; run;</PRE> Fri, 19 May 2023 18:52:12 GMT ballardw 2023-05-19T18:52:12Z https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876707#M346344 <P>I have a data set as below</P><P>&nbsp;</P><P>GroupID&nbsp; MemberID StartYear EndYear</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2012&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2014</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2008&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2009</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2006&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2008</P><P>&nbsp;</P><P>I'd like to convert it into the following:</P><P>GroupID&nbsp; MemberID YearsActive</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2012</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2013</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2014</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2013</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2014</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2015</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2016</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2008</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2009</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2006</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2007</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2008</P><P>&nbsp;</P><P>Thank you!</P> Fri, 19 May 2023 16:48:09 GMT https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876707#M346344 Amelia6 2023-05-19T16:48:09Z https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876720#M346346 <P>&nbsp;</P> <P>If your start and end year values are numeric this should work.</P> <PRE>data want; set have; do YearsActive = StartYear to Endyear; output; end; keep groupid memberid yearsactive; run;</PRE> Fri, 19 May 2023 18:52:12 GMT https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876720#M346346 ballardw 2023-05-19T18:52:12Z https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876739#M346352 <P>It works beautifully! Thank you so much!</P> Sat, 20 May 2023 03:08:14 GMT https://communities.sas.com/t5/SAS-Programming/Enumerate-years-from-a-range/m-p/876739#M346352 Amelia6 2023-05-20T03:08:14Z