proc sql;
create table test as
select catg as catg1, sum(apps) as apps, gla,mdy
from test2
group by catg,apps,gla
;quit;
Output
catg apps gla mdy
233 1 100 01jun2014
233 3 100 01jun2014
234 5 50 01jul2014
235 5 100 01aug2014
Aggregate totals not working how can I get this instead
catg apps gla mdy
233 4 200 01jun2014
234 5 50 01jul2014
235 5 100 01aug2014
So in this exmple the 233 should be totalling since the catg repeats
You will have to show what the input data set looks like. Best is as a data step so there is no question about data type or other characterisitc.
Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.
But since your data apparently has values of GLA = 100 then when you group by GLA you are not going to get any sum=200.
You shouldn't have apps in the select or group statements if you want to summarize that variable.
Remeber to define your grouping variables first and put them in your Select/Group statements and then do you summary statistics.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.