topic Re: Replicate rows based on weight in SAS Programming

Replicate rows based on weight

cindyforest7 — Tue, 07 Oct 2014 13:44:48 GMT

Hi,

Now I have a table with 5000 contracts and each contract has different membership. There is a metric measuring the performance of that contract.

Contract_id membership metric

H4510 2000 90%

H0028 5230 80%

H2309 2341 95%

..... ..... .....

Now I want to replicate each contract row by membership-times. For example, replicate the first row (H4510) by 2000 times and second row (H0028) by 5230 times and so on.

Does anyone know how to do that?

Thank you so much!

Re: Replicate rows based on weight

RaviKommuri — Tue, 07 Oct 2014 14:03:40 GMT

You can use this.....

data have;

Input contid $ membship metric $;

datalines;

H4510 2 90

H0028 5 80

H2309 2 95

;

data want(drop=i);

set have;

do i=1 to membship;

output;

end;

run;

Re: Replicate rows based on weight

ballardw — Tue, 07 Oct 2014 14:41:44 GMT

For many analysis steps you may be able to use your membership variable as a FREQ variable.