Insert new rows based on numbers of other columns

MB_Analyst — Mon, 04 Mar 2019 14:01:37 GMT

I have data for people in this form:

DATA have;
    INPUT id start_age end_age;
    DATALINES;
    1 27 30
    2 15 15
    3 30 32
    ;
RUN

I want to add a new row for every year of data between the two ages, inclusive of start and end ages. My desired output looks like:

ID age_year

1 27

1 28

1 29

1 30

2 15

3 30

3 31

3 32

Should I use an array and within a do loop add rows for i=start_age to end_age?

Re: Insert new rows based on numbers of other columns

RW9 — Mon, 04 Mar 2019 14:15:07 GMT

Please dont code all in uppercase. A simple do loop and output will suffice:

data want (drop=start_age end_age);
  set have;
  do age=start_age to end_age;
    output;
  end;
run;