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>
Organization: cotse
Subject:      How to summarize proc summary output?

Anonymous post.


Hello:

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;
   output out=total(drop=_type_);
quit;

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:

A 100
B 22
A 238
B 111

Is there an easy way in SAS to re-summarize this so that
the output is simply the sum of the group totals:

A 338
B 133

?

Or should I be approaching the problem differently?
Thanks for any assistance, pointers to procs, etc!

-Kick SAS


--
Posted Anonymously.