i have made progress in converting my excel data file. The data is now being read correctly. The code is working fine, the log file is reproduced below. QUESTION : my source file has 138000 observation out of which only 65535 were read. I have set obs = 150000 would be very grateful for your help best regards and thanks raman libname TEST1 'F:test'; filename indata1 'F:test\KDATA100.csv'; data TEST1.K11_Out;length St_Time $ 22;infile indata1 dsd dlm=',' obs= 150000 lrecl=120 truncover;input SC $ TKTID CUSTID $ ProdID: $10. EmpIDQTY Tax:5.2 R_Prix:7.2 D_A:7.2 D_P:5.2 T_Amt:8.2 St_Time $ B_type $M_Disc O_disc:7.2 S_Sta $ ; run; 226 libname TEST1 'F:test';NOTE: Libref TEST1 refers to the same physical library as TMP7.NOTE: Libref TEST1 was successfully assigned as follows: Engine: V9 Physical Name: F:\test227 filename indata1 'F:test\KDATA100.csv';228229 data TEST1.K11_Out;230 length St_Time $ 22;231 infile indata1 dsd dlm=',' obs= 150000 lrecl=120 truncover;232 input SC $ TKTID CUSTID $ ProdID: $10. EmpID233 QTY Tax:5.2 R_Prix:7.2 D_A:7.2 D_P:5.2234 T_Amt:8.2235 St_Time $ B_type $236 M_Disc O_disc:7.2 S_Sta $ ;237238239240241 run; NOTE: The infile INDATA1 is: Filename=F:\test\KDATA100.csv, RECFM=V,LRECL=120,File Size (bytes)=6548068, Last Modified=15Sep2016:07:19:31, Create Time=15Sep2016:07:13:18 NOTE: 65535 records were read from the infile INDATA1. The minimum record length was 84. The maximum record length was 112.NOTE: The data set TEST1.K11_OUT has 65535 observations and 16 variables.NOTE: DATA statement used (Total process time): real time 0.19 seconds cpu time 0.17 seconds
... View more