An easy way is to do a Tables Summary of the entire data table.
Group on every single column in the data table. This works if the
rows are completely duplicated. Delete the Nrows column and the
summary table should be exactly what you want.
Laura
--- In jmp-l@yahoogroups.com, "James T Metz" <james.metz@a...> wrote:
> JMP Users,
>
> Can someone please help.
>
> I am looking for a procedure, formula, or JSL script that
will
> either mark or remove a row from a data table for
> which one of the columns contains more than one identical entries
> (duplicates, triplicates, etc.) based on a particular
> column e.g., "Compound ID".
>
> For example, I have a data table. One of my (character)
columns
> is named "Compound ID". I have 3 rows out
> of 25,000 rows which have the same identical Compound ID - "JTM-
00001A". I
> also have other duplicates such as
> 2 rows with Compound ID -"JTM-12345B", 2 rows with Compound ID -
> "JTM-67895A" and so forth. I want to generate
> another table which contains single, unique Compound ID's i.e.,
there are
> no duplicate names. You may also assume
> that you can either mark or remove any of the duplicate or
triplicate or
> ... rows i.e., the information in the other columns
> is the same. I want to retain all of the rows which are not
duplicates,
> triplicates, etc.
>
> Does anyone have any intelligent way to do this? I can
search for
> (and remove) duplicates using the Histogram
> platform (with character data), but this is very tedious and
inefficient!
>
> I would be most grateful if someone could help. Thank you!
>
> Regards,
> Jim Metz
>
>
> James T. Metz, Ph.D.
> Research Investigator Chemist
>
> GPRD R46Y AP10-2
> Abbott Laboratories
> 100 Abbott Park Road
> Abbott Park, IL 60064-6100
> U.S.A.
>
> Office (847) 936 - 0441
> FAX (847) 935 - 0548
>
> james.metz@a...
>
> This communication may contain information that is legally
privileged,
> confidential, or exempt from disclosure. If you are not the
intended
> recipient, please note that any dissemination, distribution, use,
or
> copying of this communication is strictly prohibited. Anyone who
receives
> this message in error should notify the sender immediately by
telephone or
> return email and delete it from his or her computer.
|