Date: Thu, 15 Aug 2002 13:41:12 -0400
Reply-To: Mike Fay <rmf4@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mike Fay <rmf4@CDC.GOV>
Subject: Just get unique records or counts?
(please ignore previous post; I accidentally tabbed to Send)
I have several situations where I have a lot of duplication in records and
want to know e.g. how many different (unique) values are found in Field3.
For example, what states does a list of 1,000 students come from; are all
The easiest that I, as a newbie, have been able to get to this is to use
proc freq data=hazdat.assess noprint;
tables dSiteID/list out=work.Assess_NPL0;
and then the Log shows a record count (if I want a count of the unique
values) and the OUT= file shows the actual value (but has a few other
Is there some other way to just get a count and/or just output the unique
values in e.g. a Data statement? I thought I once saw a Unique qualifier
that could be used in this regard, but can't seem to tease a related use
out of Help now.
This is a minor question, since I can get what I want... but I have a
feeling I am missing some capability etc. This would be typical :)