Claudine -
When I run it here the tally command reports every value of the
column being tallied, both those where the count = 1 and those where the
count > 1. Are you sure you have rows in your test data where there is only
one exemplar of one or more specific values in the column being tallied such
that some values of that column occur only one time? If all of the values
being tallied occur more than once in the table the command will look like
it's working when it isn't.
Bernie
At 03:07 PM 10/15/2002 -0500, you wrote:
>Sorry, I tested it before I sent the reply and it does work. ~Claudine
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>On Behalf Of Bernie Corrigan
>Sent: Tuesday, October 15, 2002 2:54 PM
>To: [EMAIL PROTECTED]
>Subject: RE: Finding Duplicates
>
>Claudine -
>
> This does not work. Try testing it.
>
>Bernie
>----------------------------------------
>At 12:39 PM 10/15/2002 -0500, you wrote:
>>TALLY colname FROM tableview WHERE COUNT > 1
>>
>>~Claudine ☺
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>On
>Behalf Of Sharon Lima
>>Sent: Tuesday, October 15, 2002 12:12 PM
>>To: R:Base List
>>Subject: Finding Duplicates
>>
>>Elementary relapse!
>>
>>I know I had this at one time but today I cannot seem to find it or
>figure
>it out. I need the command to select all rows from a table where the
>id#
>has been used in more than one row.
>>
>>For example, I have 25000 rows of data and in a few cases an id# has
>been
>incorrectly used in more that one record. This happened before a rule
>was
>in place but now I want to find the duplicated id#s so pre-existing data
>will not be in violation of the rule.
>>
>>Thanks for help.
>>
>>Sharon
>>
>>
>>
>>
>>
>>================================================
>>TO SEE MESSAGE POSTING GUIDELINES:
>>Send a plain text email to [EMAIL PROTECTED]
>>In the message body, put just two words: INTRO rbase-l
>>================================================
>>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>>In the message body, put just two words: UNSUBSCRIBE rbase-l
>>================================================
>>TO SEARCH ARCHIVES:
>>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>>
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
