Sums and Groups 1

[DonaZ]

I have the following fields:

ID
Level
Invites
Attends
NoShows
Region
City

I want totals of invites, attends, no shows by region and by city.

I am having problems.

This worked and returned the correct total:

proc sql;
create table DR2008TEST as
select level, sum(invites) as invites, sum(attends) as attends,sum(NoShows) as NoShows
from Test1
group by level
;
quit;

I have problems when I begin to group for region and city.

Any Suggestions. Thank you in advance for your time.

DonaZ

 

[ChrisW75]

What problems do you have?

proc sql;
create table DR2008TEST as
  select region
        ,sum(invites) as invites
        ,sum(attends) as attends
        ,sum(NoShows) as NoShows
  from Test1
  group by region
;
quit;

... should work just fine.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[DonaZ]

Thank you Chris.