BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
BrahmanandaRao
Lapis Lazuli | Level 10
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  

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Simply drop transc_id from the Class Statement.

 

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

View solution in original post

1 REPLY 1
PeterClemmensen
Tourmaline | Level 20

Simply drop transc_id from the Class Statement.

 

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

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1045 views
  • 0 likes
  • 2 in conversation