D
Duke578
Guest
Is it possible to only show results where by the same cust-num appears more than 3 times.
I have tried using a variable ( count = count + 1.). but its counting all the results .
icount = kcount + 1.
display
cust-name cust-num state count
Cust Num Name State Count
1001 Apple NH 1
1001 Apple NH 2
1001 Apple NH 3
1002 Orange BD 6
1002 Orange BD 7
1002 Orange BD 8
1002 Orange BD 9
Expected
Cust Num Name State Count
1001 Apple NH 1
1002 Orange BD 2
Continue reading...
I have tried using a variable ( count = count + 1.). but its counting all the results .
icount = kcount + 1.
display
cust-name cust-num state count
Cust Num Name State Count
1001 Apple NH 1
1001 Apple NH 2
1001 Apple NH 3
1002 Orange BD 6
1002 Orange BD 7
1002 Orange BD 8
1002 Orange BD 9
Expected
Cust Num Name State Count
1001 Apple NH 1
1002 Orange BD 2
Continue reading...