Date: Sat, 11 Dec 1999 18:36:53 -0500
Reply-To: Kick SAS <anonymous@COTSE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Kick SAS <anonymous@COTSE.COM>
Subject: How to summarize proc summary output?
Suppose I have a data set with groups, countries, and
_FREQ_, from proc summary, created something like this:
proc summary nway order=freq data=all;
by group country;
A Canada 100
B Canada 22
A USA 238
B USA 111
A France 31
B France 12
Now if I apply a where clause to the data set to look
at North American countries only, and drop the country,
the output data set looks like this:
Is there an easy way in SAS to re-summarize this so that
the output is simply the sum of the group totals:
Or should I be approaching the problem differently?
Thanks for any assistance, pointers to procs, etc!