Thanks a lot, Arthur. Successfully worked. ... View more

Exactly yes I used your code. Below is the code. I used the dlm because as you said when I move my curser between fields it's immediatelly jumping to the next field. Note: I'm using SAS EG 5.1. Yes all records are one line. here's an example of the raw txt file: Vndr_id_cust Year_2011 Year_2012 Year_2013 0000002111 - ABC CORPORATION  85032386.25 123252387.54 110031088.50 data work.rev;   INFILE "/vendorlst.txt"            DELIMITER='09'x            TRUNCOVER            LRECL=32767            FIRSTOBS=2; LENGTH       vndr_id $10       vndr_id_cust cust $200; INPUT       vndr_id       @'- ' cust &       @1 vndr_id_cust &       Year_2011      Year_2012      Year_2013; RUN; Here is the result of this code. Please let me know how vndr_id_cust column info can be distributed into the rest of the fields?  so, cust Year_2011 Year_2012 Year_2013 are blank vndr_id vndr_id_cust cust Year_2011 Year_2012 Year_2013 0000002111 0000002111 - ABC CORPORATION 85032386.25 123252387.54 110031088.50 ... View more

Thanks a lot for your valuable time on this. Please see my comments below and let me know if anything is needed to change my current code. data work.rev;   INFILE "/vendorlst.txt"            DELIMITER='09'x-----Yes this is a difference but If I remove as you did on your code, most of the columns will be blank            MISSOVER---If I change to TRUNCOVER it is same/nothing changed.            LRECL=32767---same            FIRSTOBS=2;---same LENGTH       vndr_id $10---same       vndr_id_cust---same       cust $ 200; ---same INPUT       vndr_id       @'-' cust ---Yes Difference - This is what I don't understand & on your code, Can you please explain this & sign?       @1 vndr_id_cust---Yes Difference - This is what I don't understand & on your code       Year_2011       Year_2012       Year_2013;       format Year_2011 Year_2012 Year_2013 comma18.2; Run; ... View more

data work.rev;   INFILE "/vendorlst.txt"            DELIMITER='09'x            MISSOVER            LRECL=32767            FIRSTOBS=2; LENGTH       vndr_id $10       vndr_id_cust       cust $ 200; INPUT       vndr_id       @'-' cust       @1 vndr_id_cust       Year_2011      Year_2012      Year_2013;       format Year_2011 Year_2012 Year_2013 comma18.2; RUN; ... View more

Thanks, Arthur - Now, when I removed & in  @1 vndr_id_cust & the rslt changed to the following which is very close to what I want  Now, how could I populate the cust column? ... View more

I'm still having result issues. when I used the last code above. Here is the output result so customer column and Year columns are blank because all their information has been put in place under vndr_id_cust column. My result should be something similar as ... View more

By following your above code, still I'm not getting the right result. Here's my code data work.rev;   INFILE "/vendorlst.txt"            DELIMITER='09'x            MISSOVER            LRECL=32767            FIRSTOBS=2; LENGTH vndr_id_cust $200         vndr_id $10         cust $ 200; INPUT  Vndr_id_cust         vndr_id $         @'-' cust $         Year_2011        Year_2012        Year_2013; RUN ... View more

Thanks a lot, Arthur! That solved my issues. There's a column in the file that I would like to break it as follows. Now, the file has Vndr_id_cust column and I would like the vndr_id and cust to be seperated in two columns (e.g: vndr_id and Cust). Any help is appreciated. ... View more

Thanks, Arthur. To correct on my previous post due typo error. id_cust is same as Vndr_id_cust. Here’s an example of the Input file in txt file I'm using Vndr_id_cust     Year_2011           Year_2012           Year_2013 ABC CORPORATION       85032386.25       123252387.54     110031088.50 SAS output Result ... View more