Hi All,

I've set of values shown below, where
1.Set of records to be considered - if sum of C2 produces 1 or 'more', on every BY field
2.Set of records to be ignored - if sum of C2 produces 0, on every BY field

  
C1	C2
	
A     	0
A	0
A	0
	
B	0
B	1
B	0
B	1
	
C	1
C	0
C        0
C	0
	
D	0
D	0

Here, A & D has to be ignored, while B & C has to be displayed.

Any help on this would be greatly appreciated.

Thanks,
Rifaz

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

Use a two-verb request
(the first producing one row per distinct combination of the grouping keys; the second producing multiple rows per combination),
and a "where total" screening condition relating to an object of the first verb.

Something like

table ...

sum max.c2 noprint
by whatever

print c1 c2
by whatever

where total max.c2 gt 0;

...

From your description, I take it C2 is a non-negative integer, so either SUM. or MAX. can be used.

Thanks much Jack