Hi, I have a comma delimited file .csv created out of lotus notes db, I have renamed the file to .txt and I have FTPed the file to Mainframes. I am unable to read the file on Mainframes and receiving error invalid data on all the input lines. Sample of the Input as seen on the Mainframe: JReF No.,TRUS No.,TRUS Name,Trustees Bank,Stamp Code,Penaltys Number,Type,PEN Amount ,Trust Amount ,Funds Held ,Total Penaltys 57735,15286,ABCDE ABCDEDEFGHI COMPANY (UN),515,,35645311,L,$0.11 ,$0.00,$0.00,$0.11 52715,55325,ABABCDEDFGHKI ADLADJFD SLK ,515,,31954258,L,$0.16 ,$0.00,$0.00,$0.16 52715,55325,ABABCDEDFGHKI ADLADJFD SLK ,515,,31954258,L,$0.17 ,$0.00,$0.00,$0.17 11955,22956,LIONSDENIT INC. PP. LTD.,515,,35644876,L,$0.17 ,$0.00,$0.00,$0.17 My Code: DATA UPLOAD1; INFILE UPLOAD DLM=',' DSD RECFM=VB LRECL=256; /* Please note, I also tried FTPing the file into a fixed 200 lrecl file and tried the same code */ INPUT FLD1-FLD10 :$20.; PUT 'FLD1= ' FLD1; PUT 'FLD2= ' FLD2; PUT 'FLD3= ' FLD3; RUN; SAS Log: NOTE: Invalid data for FLD1 in line 1 1-8. NOTE: Invalid data for FLD2 in line 1 10-17. NOTE: Invalid data for FLD3 in line 1 19-27. 2 The SAS System NOTE: Invalid data for FLD4 in line 1 29-41. NOTE: Invalid data for FLD5 in line 1 43-52. NOTE: Invalid data for FLD6 in line 1 54-69. NOTE: Invalid data for FLD7 in line 1 71-74. NOTE: Invalid data for FLD8 in line 1 76-85. NOTE: Invalid data for FLD9 in line 1 88-99. FLD1= . FLD2= . FLD3= . RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 1 JReF No.,TRUS No.,TRUS Name,Trustees Bank,Stamp Code,Penaltys Number,Type,PEN Amount ,Trust Amount 101 ,Funds Held ,Total Security 128 FLD1=. FLD2=. FLD3=. FLD4=. FLD5=. FLD6=. FLD7=. FLD8=. FLD9=. FLD10=Funds Held NOTE: Invalid data for FLD3 in line 2 13-42. NOTE: Invalid data for FLD7 in line 2 58-58. NOTE: Invalid data for FLD8 in line 2 60-64. NOTE: Invalid data for FLD9 in line 2 67-71. FLD1= 57735 FLD2= 15286 FLD3= . 2 57735,15286,ABCDE ABCDEDEFGHI COMPANY (UN),515,,35645311,L,$0.11 ,$0.0 FLD1=57735 FLD2=15286 FLD3=. FLD4=515 FLD5=. FLD6=35645311 FLD7=. FLD8=. FLD9=. FL Can anyone please help where I am doing the mistake? I am using SAS 9 on Mainframes (z/os) . Thank You!! Rgds HK_Endeavour Forever
... View more