I have no words to thank you. its a reward for me that u have used impressed word for me. Thanks a lot. ... View more

sorry for one mistake in my last paste code, kindly change series_id as id; thanks ... View more

first of all i highly apology for my silly mistake which make trouble to import data. Thanks for ur kind help,,, i believe its very helpful in my project. but my desire output is to group all four [3-6 ] convert in or rename in one common id and rest value comes infront of that. please check my effort n will wait for ur kind suggestion. ---------------------------- proc import datafile="C:\Users\loveislife\Desktop\banktest.txt" out =test dbms=dlm replace; delimiter='09'x; getnames=yes; run; data a(rename=(value=Value_A)) b(rename=(value=Value_B)) c(rename=(value=Value_C)) d(rename=(value=Value_D)); set test(keep=id year Month value); if _n_=1 then do; flag=0; y=substr(id,1,3); end; if y =substr(id,1,3) then do; y =substr(id,1,3);x="A"||substr(id,4,1); if x="A3" then output a; if x="A4" then output b; if x="A5" then output c; if x="A6" then output d; end; if y ne substr(id,1,3) then do; y =substr(id,1,3); flag=flag+1; x="A"||substr(id,4,1); if x="A3" then output a; if x="A4" then output b; if x="A5" then output c; if x="A6" then output d; end; retain flag y; drop x y; run; data new(drop =flag); merge a b c d; by flag year month; run; ------------------------------- ... View more

"Throgh this i got my result , but as per my concern it doesn't look like profession and appropriate  Kindly suggest me anything more short and appropriate with using macro" applogy for trouble . After importing table as work.test data a(rename=(value=Value_A)) b(rename=(value=Value_B)) c(rename=(value=Value_C)) d(rename=(value=Value_D)); set test(keep=id year Month value); if _n_=1 then do; flag=0; y=substr(id,1,3); end; if y =substr(id,1,3) then do; y =substr(id,1,3);x="A"||substr(series_id,4,1); if x="A3" then output a; if x="A4" then output b; if x="A5" then output c; if x="A6" then output d; end; if y ne substr(id,1,3) then do; y =substr(id,1,3); flag=flag+1; x="A"||substr(id,4,1); if x="A3" then output a; if x="A4" then output b; if x="A5" then output c; if x="A6" then output d; end; retain flag y; drop x y; run; data new(drop =flag); merge a b c d; by flag year month; run; ... View more

thanks for ur help sir, yes i m using conditions but i m not getting proper result. pattern is, always last digit will vary 3-6 and rest would be same for particular person. kindly suggest. ... View more

Thanks for your kind help. i would like to share my effort with you please suggest me  and please any one can help me to know what is the use of  'nofs' ? proc report data=bank nowd ; column accttype branch,amount amount; define accttype/group; define branch/across; define amount /analysis sum; compute after; Accttype="Total:"; endcomp; rbreak after / dol dul summarize; run; ... View more

Thanks for your kind help. ... View more

Thank you very much for your kind help. sir i would like to add one thing that your ans is suitable for only this sample data in exact this format. but  if i will change place of any field value(means adding one or more space in between) so it will give wrong ans. which is possible to come in complete population. i tried something but it is not working in name field. data test;   infile datalines truncover dlm=",";   input @;   _infile_=tranwrd(_infile_,' ',",");   input x 1-2 y $ z;   datalines; 34     aman 56 56 vikash               34 34   aman 56 56     vikash 34 34   aman 56              34           aman       56 56   vikash 34 34   aman 56 56 vikash 34      56 56 vikas ; run; Kindly suggest me .... ... View more