topic Counter that increments a variable and adds those incremented versions as additional rows in SAS Programming

Counter that increments a variable and adds those incremented versions as additional rows

rosegarden81 — Fri, 24 Aug 2018 01:25:49 GMT

Hello,

I am stuck on how to proceed on the below. My original data looks like this:

I would like to transform the above data to something like the below:

Any advice would be highly appreciated..

Regards,

Tina

Jagadishkatam — Fri, 24 Aug 2018 01:30:25 GMT

data have;
input aa bb;
cards;
1 10
11 15
16 25
;

data want;
set have;
do newvar=aa to bb;
output;
end;
run;

rosegarden81 — Fri, 24 Aug 2018 17:40:50 GMT

Thank you so much! This worked wonders!