I want to filter on records which has "Y" across id's and exclude id's which has "Y" for some id and "N" or missing for the rest. data WORK.ADS; infile datalines dsd truncover; input ID:BEST12. ecs:BEST12. par:$8. flag1:$1.; datalines4; 12,1,par1,Y 12,2,par1,Y 12,3,par1,Y 12,4,par2,Y 13,1,par1, 13,2,par1,Y 13,3,par1,N 13,4,par2,Y 14,1,par1,N ;;;; i would only want observations as it has "Y" for all id, ecs, par 12,1,par1,Y 12,2,par1,Y 12,3,par1,Y 12,4,par2,Y any help on how to get them
... View more