Date: Wed, 10 Oct 2001 18:28:11 -0700
Reply-To: "Karsten M. Self" <kmself@IX.NETCOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Karsten M. Self" <kmself@IX.NETCOM.COM>
Subject: Re: count for each level of an categorical variable
In-Reply-To: <email@example.com>; from
shpzh2000@YAHOO.COM on Wed, Oct 10, 2001 at 06:05:05PM -0700
Content-Type: multipart/signed; micalg=pgp-sha1;
on Wed, Oct 10, 2001 at 06:05:05PM -0700, Rich (shpzh2000@YAHOO.COM) wrote:
> My sorting problem got solved. Thank you all very much.
> Now I came to another prob.^:^
> The 8GB dataset has 3.5 millon obs. There is a categorical variable
> with a lot of levels. For each level, I would like to know the
> corresponding count. I used PROC FREQ, but it used up all my memory
> pretty soon. Is there any trick to get around this problem? Seems like
> the PROC FREQ is very memory-consuming, right?
Post your code and FULLSYSTIMER output.
select distinct var, count( * )
group by var
Karsten M. Self <firstname.lastname@example.org> http://kmself.home.netcom.com/
What part of "Gestalt" don't you understand? Home of the brave
http://gestalt-system.sourceforge.net/ Land of the free
Free Dmitry! Boycott Adobe! Repeal the DMCA! http://www.freesklyarov.org
Geek for Hire http://kmself.home.netcom.com/resume.html