topic Re: Splitting one row with multiple ages into multiple rows with one age each in New SAS User

Splitting one row with multiple ages into multiple rows with one age each

rav31 — Mon, 08 Jul 2019 19:51:23 GMT

I have a large dataset where each rate is the same for all ages between age_first and age_last. Below is an example of one row of the dataset:

age_first age_last rate

15 20 4.16

My goal is to convert this row into many, with one row for each age, like so:

age rate

15 4.16

16 4.16

17 4.16

18 4.16

19 4.16

20 4.16

Re: Splitting one row with multiple ages into multiple rows with one age each

Reeza — Mon, 08 Jul 2019 19:52:59 GMT

Use those values as the do loop start and stop.

data want;
set have;

do age=age_first to age_list;
       output; *writes a record for each age;
end;

run;

@rav31 wrote:

I have a large dataset where each rate is the same for all ages between age_first and age_last. Below is an example of one row of the dataset:

age_first age_last rate

15 20 4.16

My goal is to convert this row into many, with one row for each age, like so:

age rate

15 4.16

16 4.16

17 4.16

18 4.16

19 4.16

20 4.16

Re: Splitting one row with multiple ages into multiple rows with one age each

Kurt_Bremser — Mon, 08 Jul 2019 19:53:38 GMT

Simple do loop:

data want;
set have;
do age = age_first to age_last;
  output;
end;
keep age rate;
run;