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
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