Date:         Mon, 20 Dec 2004 15:19:00 -0800
Reply-To:     ezhou@SHAW.CA
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Eric Zhou <ezhou@SHAW.CA>
Organization: http://groups.google.com
Subject:      Re: count number of transaction
Content-Type: text/plain; charset="iso-8859-1"

It is actually an SQL question.

proc sql;
create table txn as
select  id, count(id)  from transaction having transid =4;
quit;

but that' s not what I want. I need count both transid 1 and 4 and
count transaction 1 only for IDs

Eric