Thank you Tom. Appreciate your prompt response ... View more

oops my bad,  i did something wrong. I got perfect output with you code EJ. Thank you so much. Thank you for your input ballrdw. one small question how to insert that extraword 'Total' in report ... View more

I'm a regex fan, so here's another approach: *  your first example ; data a; input info $1-50; cards; 101 pencils 35 102 parker pensl21 103 dellstudioipod 04 104 dellstudioipod 01 run; * your second example ; data b; input info $1-50; cards; 101 pencils 35 102 parker pens 21 103 apple ipod touch n shuffle 04 104 dell studio ipod 01 run; data want;    set a;  * or set b ;    rx=prxparse("/^(\d+)(\D*)(\d+)$/o");    rc=prxmatch(rx,trim(info));    prid=input(prxposn(rx,1,info),best.);    prname=prxposn(rx,2,info);    prqty=input(prxposn(rx,3,info),best.); run; This will assign: 1) prid = beginning of line, all digits up to 2) prname = all non-digits, up to 3) prqty = all digits at the end of line ... View more

Thank you so so much ballardw. your code worked and i need to do little bit ODS style formats. ... View more

Most likely you have a space after the tab and before the date value. Try using : modifier in front of the date format.  I worry that if your data is inconsistent about whether the extra character is there you might skip over the first actual digit of the date value using the +1 cursor movement command.  See example below using | in place of tabs. data test;   infile cards dlm='|' truncover ;   input id 3. date :date9. ;   format date date9.;   put (id date) (=); cards; 001|11jan2012 002| 11jan2012 003 21jan2012 run; ... View more

Thank you all for your input I got right output. ... View more