Weighted Average

Reply
New Contributor
Posts: 2

Weighted Average

I am trying to caculate a weighted average interest rate. I have monthly loan origination data for multiple products, multiple rate types, and several years of history. Variable names: product, Rate_Type, Origination_year, Origination_month, interest rate, origninal_unpaid_balance. I am having trouble writing a program that can handle all the changing parts. The final product needs to have a weighted interest rate for each month(weighted on balance), for each product and rate type.

 

Thoughts?

SAS Super FREQ
Posts: 3,476

Re: Weighted Average

Please provide sample data and indicate what output you expect.

 

For an overview of weigthed means, see "Compute a weighted mean in SAS."

New Contributor
Posts: 2

Re: Weighted Average

I appreciate the quick response. I was able to resolve my issue using the weight function in SAS EG - Tasks - Summary Statistics

Ask a Question
Discussion stats
  • 2 replies
  • 250 views
  • 0 likes
  • 2 in conversation