Hi, I'm trying to create the below output from an excel solver in SAS. I don't fully understand how the excel solver works to help me understand how to produce the equivalent in SAS. In red below I have a weighted average of data_A and data_B that gives 2.42%. I have an aimed WA of 1.73%. The excel solver takes the distribution in the 'data_B' column and 'adjusts' it ('Optimal' column) to create the WA of 1.73%. I have read a similar question on this forum and I have attempted to use the PROC OPTMODEL statement within SAS however it seems to try and populate each 'Group' bucket, even though you can see there is nothing in Groups 1-9 for data_B. Any help would be greatly appreciated. Group data_A data_B Optimal 1 0.04% 0.00% 0.00% 2 0.06% 0.00% 0.00% 3 0.10% 0.00% 0.00% 4 0.12% 0.00% 0.00% 5 0.14% 0.00% 0.00% 6 0.16% 0.00% 0.00% 7 0.24% 0.00% 0.00% 8 0.38% 0.00% 0.00% 9 0.43% 0.00% 0.00% 10 0.69% 2.25% 4.24% 11 1.13% 51.46% 51.45% 12 1.27% 37.55% 37.54% 13 2.10% 3.64% 3.62% 14 3.30% 0.36% 0.31% 15 4.40% 0.03% 0.00% 16 5.50% 0.73% 0.65% 17 8.50% 0.99% 0.86% 18 10.50% 0.03% 0.00% 19 12.80% 0.88% 0.67% 20 23.60% 0.21% 0.00% 21 34.40% 0.28% 0.00% 22 55.00% 1.59% 0.66% 2.42% 1.73% Aimed WA= 1.73
... View more