Sum of sales on each cutomer_id

BrahmanandaRao — Fri, 12 Mar 2021 09:52:41 GMT

data paytm;
input cust_id transc_id amount;
datalines;
1 12 2500
1 22 3500
2 23 6000
2 41 6000
3 14 3540
3 54 3600
;
run;

	proc sql;
	select cust_id, amount,sum(amount) as total_sales
	from paytm	
	group by cust_id ;
	quit;


	proc means data=paytm ;
	class cust_id transc_id;
	var amount;
	output out =sales_sum (drop=_:) sum=;
	run;

here i did not get desired output

i want total sales amount for each customer_id

Re: Sum of sales on each cutomer_id

PeterClemmensen — Fri, 12 Mar 2021 09:58:30 GMT

Simply drop transc_id from the Class Statement.

	proc means data=paytm ;
	class cust_id;
	var amount;
	output out =sales_sum (drop=_:) sum=;
	run;

topic Sum of sales on each cutomer_id in SAS Programming

Sum of sales on each cutomer_id

Re: Sum of sales on each cutomer_id