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!
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;
For many analysis steps you may be able to use your membership variable as a FREQ variable.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.