LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page