Code to get table of sum of one variable that belongs to category in another variable

[jeremy4]

Hi,

Can someone please provide me with the code (the dataset: data=APRIL_PROJECT) so that I can see the sum of the 'BALANCE' variable ('BALANCE' is a numeric variable) that belongs to each of the categories in the 'MOVEMENT' variable ('MOVEMENT' is a character variable) i.e. there would be a table that shows that the sum/total balance would be 700 for '1 to 2' (300+400) and 450 for '2 to 1' (200+250) etc. Thanks.

[Onizuka]

Data have ;
format balance 3. movement $6. ;
input balance movement ;
cards;
500 1_to_1
300 1_to_2
200 2_to_1
500 2_to_2
400 1_to_2
250 2_to_1
125 3_to_1
600 3_to_2
350 3_to_1
;
run ;

Proc sql ;
create table want as 
select sum(balance) as sum, movement
from have
group by movement ;
run ;

[Onizuka]

I delete my previous message because it was false, my solution is working now.

here the output :

[PaigeMiller]

PROC MEANS/PROC SUMMARY was designed to do things like this, and is a basic fundamental SAS tool that (in my opinion) everyone should know. Example is here:

https://documentation.sas.com/?docsetId=proc&docsetTarget=p070bkysj4lkyun0zxj45n643q1i.htm&docsetVer...