Hi, Please can someone explain the importance of the 'group by' statement when using proc sql and examples of how it should be used (i.e. when it should be 'group by 1,2,3;' etc. - is it the number of variables selected i.e. if five variables are selected, it would be 'group by 1,2,3,4,5;' and excludes any sum(variable) as [new variable name] when considering how many to group by? I have an example below of my code - can it be reviewed to see if it is correct and whether any changes need to be made? Thanks! Code: proc sort data=test; by ID; run; proc sql; create table consumer_balance as select ID, sum(balance) as Total_balance, count(*) as Volume from test group by 1 ; quit;
... View more