Thank you Fried Egg!!! i am still researching the above FIND,GREP and SED ... ... View more

Thanks Jagadish!!! ... View more

Thank you Patrick!!! for first point i used your ls- al | grep  option to get desired list. could you please give some source for FIND command, if possible Thanks Sam ... View more

Thanks LinusH and tom. Tom, I customized few Unix cmd in alias. Could you specify "There are hundreds of editors for Unix, including running SAS interactively and using the program editor in the SAS Display Manager" some examples to know more about these Thanks Sam ... View more

Hi , It is same as jagadish approach... but a little different way. i am using jagadish have dataset. data have;     input Portfolio$    Date $     Period; cards; a    3/1/2013 0 a    3/2/2013 1 a    3/3/2013 2 b    5/1/2013 0 b    6/1/2013 1 ; run; data classdata; do period=0 to 4;   output; end; run; proc summary data=have classdata=classdata nway; by portfolio; class period; output out=temp(drop=_:);run; proc sql; create table want as select a.*,b.date from have as b right join temp as a on a.portfolio=b.portfolio & a.period=b.period; quit; Thanks Sam ... View more

Hi, another apporach, i used Mit Have dataset data have; input portfolio : $1. value; cards; A 2 A 3 A  A  B 2 B  B  B 4 B  B  ; run; data want; do until(last.portfolio); set have; by portfolio notsorted; new_val=ifn(value ne .,value,new_val); output; end; run; Thanks Sam ... View more

Hi ballardw, Thank you for your response , i applied what you suggested. i am getting error like ERROR: File FORM.FORMATS.CATALOG was created for a different operating system. now i am using on Unix. how to resolve this format issue Thanks Sam ... View more

Thank you so much  Anca. It worked!!!!! That is what exactly i want. Regards Sam. ... View more

Hi Anca, Thank you !!! I Tried  PCTN but i used wrong variable , i am applying on grp!!!! . Now i  got what i want. Is the same table can we generate using proc report. because i need to add another variable like sec(afafa,dsfsa ‚fdafa) , that varible name is mflag(Yes,NO). i am unable to do it in one table by using proc tabluate, my final o/p with new added variable is shown like this                                                                             section                                                        mflag grp                  flg                               afafa              dsfsa           fdafa                                  Yes                   No                                                         n         %          n        %       n         %                         n         %          n        %         1                    No                            XX        XX        XX       XX       XX      XX                       XX        XX         XX       XX                       Yes                          XX        XX        XX       XX       XX      XX                       XX        XX         XX       XX I below is the code i am using but it throws a error in log: proc tabulate data=subgrps; class grp flg sec mflag; table grp *flg ,sec=’Section’ * (n='n' * f=10. PCTN<FLG>='%' * f=7.2 ), mflag=’Mflag’ * (n='n' * f=10. PCTN<FLG>='%' * f=7.2 )/ misstext='0' rts=40; run; Thanks Sam ... View more