topic Re: problem infile statement in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303731#M8620 <P>Any errors in the log?&nbsp;</P> <P>&nbsp;</P> <P>Try setting LRECL=1000 on your imfile statement, maybe it's currently too short?&nbsp;</P> <P>&nbsp;</P> <P>Also, examine your text file with an editor that has the option to show invisible characters. See if any are present in your data. Suggestions for Editors are Notepad++ or Textwrangler.&nbsp;</P> Tue, 11 Oct 2016 08:42:57 GMT Reeza 2016-10-11T08:42:57Z problem infile statement https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303730#M8619 <P>Hi all,</P><P>I am having problem with infile statement. It doesnot read all columns from text file. I have 25 comlums, but only 22 read, the last 3 in sas are missing values .... I have tried several options (truncover, missover....). It just does not work.&nbsp;</P><P>my data file (25 comlumns):</P><P>1 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 -78.0463 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 -9999.00 -9999.00<BR />2 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 469.880 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 -9999.00 -9999.00<BR />3 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 977.898 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 -9999.00 -9999.00<BR />4 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 -419.711 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 -9999.00 -9999.00<BR />5 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 515.784 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 -9999.00 -9999.00</P><P>sas:</P><P>data import_all1;<BR />infile "C:\grouping\dat2.txt" truncover;<BR />input var1-var25;<BR />run;</P><P>&nbsp;</P><P>Output (22 variables have values, the rest 3 are just . . .:</P><P>1 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 -78.0463 -9999.00 -9999.00 -9999.00 1.00000 . . .&nbsp;<BR />2 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 469.880 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 . . .&nbsp;<BR />3 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 977.898 -9999.00 -9999.00 -9999.00 1.00000 -9999.00 . . .&nbsp;<BR />4 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 -419.711 -9999.00 -9999.00 -9999.00 1.00000 . . .&nbsp;<BR />5 0 0 1 1 -9999 -9999 -9999 -9999 1000001 -9999 -9999 -9999 1 -9999 -9999 -9999 515.784 -9999.00 -9999.00 -9999.00 1.00000 . . .&nbsp;</P><P>&nbsp;Please help. Thank you</P> Tue, 11 Oct 2016 08:38:38 GMT https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303730#M8619 landcruiser 2016-10-11T08:38:38Z Re: problem infile statement https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303731#M8620 <P>Any errors in the log?&nbsp;</P> <P>&nbsp;</P> <P>Try setting LRECL=1000 on your imfile statement, maybe it's currently too short?&nbsp;</P> <P>&nbsp;</P> <P>Also, examine your text file with an editor that has the option to show invisible characters. See if any are present in your data. Suggestions for Editors are Notepad++ or Textwrangler.&nbsp;</P> Tue, 11 Oct 2016 08:42:57 GMT https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303731#M8620 Reeza 2016-10-11T08:42:57Z Re: problem infile statement https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303732#M8621 <P>Thank you, Reeza.&nbsp;</P><P>"LRECL =1000" works.</P> Tue, 11 Oct 2016 08:46:22 GMT https://communities.sas.com/t5/SAS-Data-Management/problem-infile-statement/m-p/303732#M8621 landcruiser 2016-10-11T08:46:22Z