I have a file with part numbers, and some parts are showing multiple times in the database. I only want to display the parts in my output if there are more than one occurence of that part.
For example the table may look like:
Part Qty
6203 100
6203 400
6204 200
6205 300
Only both instances of 6203 should display in the output.
Can someone tell me the most efficient way to achieve this?

This message has been edited. Last edited by: Donald,

Try something like this -

TABLE FILE CAR
  SUM COMPUTE COUNTER/I9 = CNT.MODEL; NOPRINT
   BY COUNTRY
   BY CAR
PRINT MODEL
   BY COUNTRY
   BY CAR
WHERE TOTAL COUNTER GT 1
END

T

Worked perfectly, thank you.

To add CLOSED to your title, you can edit your original post in the thread.