Date: Wed, 7 May 2008 11:57:10 -0400
Reply-To: "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Fehd, Ronald J. (CDC/CCHIS/NCPHI)" <rjf2@CDC.GOV>
Subject: Cardinality Ratio
Content-Type: text/plain; charset=us-ascii
I have had some good commentary on my SmryEachVar data review suite
and am considering writing a program which calculates
only the Cardinality Ratio.
http://tinyurl.com/5grpgn for
http://www.sascommunity.org/wiki/Cardinality_Ratio
My main SmryEachVar routine, ProcFreq, provides a data set
which I use to get the NobsUnique which I use to calculate the
CardRatio.
The above url provides examples using Proc Freq, Proc Sort and Proc SQL.
I wonder if anyone can fill in the blanks for the hash table solution?
My goal is to provide the fastest tool, other than Proc Freq,
to get only the number of unique values of a variable.
Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
|