Thank ,it worked for my sample data, but i have a another grp which i missed. Not only 0 & 1 if any of the grp have val 0 then the need to assign another val value to negative too in the below case , xxx, aaaa, bbbb, cccc val values should be -val data have; input id grp1 $ val $; cards; 100   xxxx    0 100   xxxx    1 100   yyyy    .33 100   yyyy    .67 100   zzzz    .5 100   zzzz    .5 100   aaaa   1 100   aaaa   0 100   bbbb   0.63 100   bbbb   0 100   cccc    0 100   cccc    .4 100   dddd    1 100   dddd    1 100   eeee    0 100  eeee     0 ; run; data want; input id grp1 $ val; cards; 100   xxxx     0 100   xxxx    -1 100   yyyy    .33 100   yyyy    .67 100   zzzz    .5 100   zzzz    .5 100   aaaa   -1 100   aaaa    0 100   bbbb   -0.63 100   bbbb   0 100   cccc    0 100   cccc    -.40 100   dddd    1 100   dddd    1 100   eeee    0 100  eeee     0 ; Thanks Sam Message was edited by: peda sam ... View more

Hi Rakesh, If i understood right!!! this is one way to get the output you want... Below code is DoW approach!!! data want; do until(last.id);   set have;    by id;    if visit eq 2 then flg=1; end; do until(last.id); set have; by id; if missing(flg) then output; end; run; Thanks Sam ... View more

Thank you all, every method work like a champ.. Thanks Sam ... View more

Thank you Art!!!! But in above example, i gave a example for time period up to 12, but in my real data time period is up to 300. i am something looking in loop. do i =0 to 300 by 3   :- time period Thanks Sam ... View more

Thank you data _null_. I was not successful at first macro variable itself. so i am getting issue. Thanks Sam ... View more

Thanks to both!!! Work like champ!!!! COuld you please explain what special character matches (/) & space?  From the variable var....In the above regular expression Thanks sam ... View more

Thank you FriedEgg, i am under learning curve. i would like to achieve that using regular expression Thanks Sam ... View more

I am considering the RW9 approach, data have;   length method1-method3 $20;   id=1; method1="Text"; method2="Email"; method3="Personal phone call"; output;   id=2; method1="Email"; method2="Personal letter"; method3=""; output;   id=3;method1="Personal letter"; method2="Personal phone call"; method3="Text"; output;   id=4;method1="Email"; method2="Text"; method3=""; output; run; data want(drop=i);   set have;    length personal $50.;     array method(3);        do i=1 to 3; if index(method{i},"Personal")>0 then personal=catx(' ',personal,method{i});        end;   run; Thanks Sam ... View more

Thank you All, I agree with you Hai.kuo. while i am practicing  with macro variables with date character variable. i got a question if we need to keep space between the date, how should i achieve it. i tried one approach i am looking for better one.. so i posted on forum. i want to learn different approach , from SAS Guru 's on this forum. Thanks Sam ... View more