I need to create a new flag with subjects which has first id as "Y" and atleast 1 flag later for same id as "Y" In the below example i want to see if ecs=1 has flag1="Y" then create flag2="Y" for that id 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 ;;;; the output i need to get is falg2="Y" for id 12,14 and flag2="N" for 13 any help
... View more