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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.