topic Re: Code to get table of sum of one variable that belongs to category in another variable in SAS Programming

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

jeremy4 — Tue, 07 May 2019 10:23:17 GMT

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.

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

Onizuka — Tue, 07 May 2019 10:31:46 GMT

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 ;

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

Onizuka — Tue, 07 May 2019 10:33:19 GMT

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

here the output :

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

PaigeMiller — Tue, 07 May 2019 12:17:18 GMT

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&docsetVersion=9.4&locale=en#p070bkysj4lkyun0zxj45n643q1i