Hi, This is the dataset.  A is numeric. A 0.1245 0.0045 0.0235 I need to convert this numeric variable to character. 'A' should be a character in my output.My output should be A 0.1245 0.0045 0.0235 I tried A1=put(A,$6); Thanks, Saravanan ... View more

Thanks for your effort and time. It works fine. Saravanan. ... View more

Thanks for your reply. It works fine. Much appreciated for your time and effort. Saravanan ... View more

Thanks for your reply. It works perfect. Much appreciated. Saravanan ... View more

Hi, Thanks for the response. your code works perfectly. Thanks a lot. Much appreciated. Saravanan ... View more

Hi , I came up with the below code which seems to work robustly. Thanks for your help. Much appreciated. data want(drop=_:); set have; by sno; retain _twoflag _threeflag; if first.sno & flag=1 & flag1=. then      do;           output;           _twoflag=0;      end; else if (first.sno & flag=10 & flag1=1) or (first.sno & flag not in (1,10) & flag1=.) then      do;           output;           _twoflag=1;           _threeflag=0;      end; if _twoflag=1 & first.sno ne 1 then      do;           if _threeflag=0 & flag not in (1,10) then output;           else if _threeflag=0 & flag=1 then                do;                     output;                     _threeflag=1;                end;           else if flag=10 then _threeflag=1;      end; run;           Thanks all who tried to help me. much appreciated. Saravanan ... View more

Hi Richard, Thanks for the response. The logic works for above data and since you warned for some combination of records it might not work, i have changed the input data to accomodate whether 10 comes in the first records or in the later records. I have added an extra flag named flag1 which will let you know if 10 comes as a first record.  is it now possible to come up with a robust logic with this modified data?. Thanks for your help the logic that has to be accompished is: within each by group (grouped by sno), if the first record has flag=1 & flag1=. then it should be output and rest of the records within the group should be ignored. if the first record(grouped by sno) has (flag=10 & flag1=1) or (flag not in (1,10) & flag1=.), then it should proceed to the subsequent record and check for the flag till it finds either flag= 1 or 10 for first time with in the By group, if the found flag is 1 then rest of the records within the By group should be ignored, else if the found flag is 10 then all records including this record and rest of the records should be ignored with in the By group. sno A B flag flag1 1 0 1 . . 1 1 1 1 . 1 10 2 10 . 1 1 1 1 . 1 10 2 10 . 2 0 1 . . 2 10 1 10 . 2 1 1 1 . 2 10 1 10 . 2 1 1 1 . 3 10 1 10 1 3 99 1 . . 3 1 1 1 . 3 10 2 10 . 4 1 1 1 . 4 0 1 . . 4 10 2 10 . now the output will look like, sno A B flag 1 0 1 . . 1 1 1 1 . 2 0 1 . . 3 10 1 10 1 3 99 1 . . 3 1 1 1 . 4 1 1 1 . Thanks for all the help. it will be great to have the robust logic achieved. Saravanan ... View more

Thank you very much for the clarification. It works. very much appreciated. Thanks, Saravanan ... View more