Hello, I am trying to calculate a weighted geomean such that: City Province Price_Relative Weight Weighted_Geomean Montreal QC 1.00321 0.65 1.003538 Quebec QC 1.00368 0.20 1.003538 Gatineau QC 1.00477 0.15 1.003538 Unfortunately, I can't seem to find a built in function that could perform this task. But, this is what I would love to be able to do (if it only existed): proc sql;
create table want as
select *, sumproduct(price_relative ** weight) as weighted_geomean
from have
group by province;
quit; Since sumproduct doesn't exist like it does in Excel, is there a simple work around? Or is there a built in function for weighted geomean that I just haven't come across? Thanks so much in advance!
... View more