topic Re: proc means in SAS Programming

proc means

Ronein — Mon, 13 Aug 2018 04:51:04 GMT

Hello

I am using proc means to calculate 3 statistics:

weighted average of interest on loans (weighted by sum of loans)

sum of loans

number of loans

In the output data set the value of sum of loans I get an error value.

I need to get 1500

data tbl;
input customer  sum_loan  interest;
cards;
1 100 5
2 200 4
3 300 4
4 400 3.5
5 500 2.8
;
run;

proc means data=tbl;
   weight sum_loan;
   var interest sum_loan;
   output out=pelet mean(interest)=weight_mean_interest
                    sum(sum_loan)=sum_loan
					n(sum_loan)=customer
;
run;

Re: proc means

novinosrin — Mon, 13 Aug 2018 05:11:02 GMT

correction:

proc means data=tbl sumwgt sum;
   weight sum_loan;
   var interest sum_loan;
   output out=pelet mean(interest)=weight_mean_interest
                    sumwgt(sum_loan)=sum_loan
					n(sum_loan)=customer
;
run;

Re: proc means

Ronein — Mon, 13 Aug 2018 05:27:13 GMT

Thank you so much.

What "sumwgt" is doing?

Is it calculating sum without weight?

Re: proc means

novinosrin — Mon, 13 Aug 2018 05:36:57 GMT

yes sir/mam . Your approach is right. Just refer the docs, you will do great