topic Re: How to make a loop to add all years from the date series in SAS Procedures

How to make a loop to add all years from the date series

PatrykSAS — Fri, 06 Mar 2020 14:14:24 GMT

Imagine I got Data set like:

ID START_YEAR END_YEAR

1 2015 2017

my target is to convert this to:

ID YEAR

1 2015

1 2016

1 2017

Do you have any solution?

Re: How to make a loop to add all years from the date series

PaigeMiller — Fri, 06 Mar 2020 14:18:17 GMT

data want;
    set have;
    do year=start_year to end_year by 1;  
        output;
     end;
    drop start_year end_year;
run;

Re: How to make a loop to add all years from the date series

PeterClemmensen — Fri, 06 Mar 2020 14:18:27 GMT

@PatrykSAS Welcome to the SAS Community 🙂

There you go

data have;
input ID START_YEAR END_YEAR;
datalines;
1 2015 2017
;

data want (keep=id year);
   set have;
   do year = start_year to end_year;
      output;
   end;
run;