Do you think, whether I can use logarithmic weighing function for frequency say log(1+f) to dampen the frequency values. How do we do the normalization factor to get the weighted mean if I combined with the importance of the items (it us expressed in another weights). Appreciate it if you could show a simple SAS Code for getting the weighted score. An example table is given for your information
Items frequency Item_weight Weights_DuetoImportance
V1 2 0.34 3
V2 1 0.15 1.5
V3 1 0.04 2
V4 3 0.12 1
V5 7 0.24 2
V6 1 0.1 2.5
V7 1 0.15 3
--------
-------
-----
V128 2 0.14 2

I am not sure how can I combined the effects of both the multiple occurrences(frequency) and importance to get the combined impact for getting a weighted average score?
Appreciate your help. Thank you