topic Re: duplicate the rows based on count in SAS Programming

duplicate the rows based on count

Jagadishkatam — Fri, 16 Oct 2020 13:09:47 GMT

Dear All,

I have the input as below where I want to duplicate the rows based on the count, like if I have the count 4 then i want to duplicate that 3 more time, if I have 3 then i want duplicate the rows 2 more times. Appreciate your response.

data have;
input count name$;
cards;
4 sample1
3 sample2
4 sample3
;

data want; 4 sample1 4 sample1 4 sample1 4 sample1 3 sample2 3 sample2 3 sample2 4 sample3 4 sample3 4 sample3 4 sample3

Re: duplicate the rows based on count

LinusH — Fri, 16 Oct 2020 13:09:20 GMT

Try a do loop with an explicit output statement.

Re: duplicate the rows based on count

Jagadishkatam — Fri, 16 Oct 2020 13:12:05 GMT

Thank you I tried below code and it worked

data want;
set have;
do i = 1 to count;
output;
end;
run;