topic Re: Import txt file in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111641#M30943 <HTML><HEAD></HEAD><BODY><P>Post the data step code generated by proc import and descriptions of what you expected. Is your data delimited or fixed column?</P></BODY></HTML> Tue, 04 Sep 2012 22:43:23 GMT ballardw 2012-09-04T22:43:23Z Import txt file https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111639#M30941 <HTML><HEAD></HEAD><BODY><P>I'm trying to import a txt file with several columns.&nbsp; I don't get any error messages but the resulting Sas dataset does not recognize all the columns and has all the data in only one column.&nbsp; How can I change the file or proc import code to recognize all the columns? Thanks for your help!</P></BODY></HTML> Tue, 04 Sep 2012 21:09:59 GMT https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111639#M30941 trich12 2012-09-04T21:09:59Z Re: Import txt file https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111640#M30942 <HTML><HEAD></HEAD><BODY><P>tell us more about the file.&nbsp; It may be better to just read it with the INFILE statement and a DATA step.</P></BODY></HTML> Tue, 04 Sep 2012 21:11:49 GMT https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111640#M30942 Doc_Duke 2012-09-04T21:11:49Z Re: Import txt file https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111641#M30943 <HTML><HEAD></HEAD><BODY><P>Post the data step code generated by proc import and descriptions of what you expected. Is your data delimited or fixed column?</P></BODY></HTML> Tue, 04 Sep 2012 22:43:23 GMT https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111641#M30943 ballardw 2012-09-04T22:43:23Z Re: Import txt file https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111642#M30944 <HTML><HEAD></HEAD><BODY><P>This question is occurred usually by not identifying the delimiter or assign a wrong delimiter.</P><P>e.g. The file's delimiter is TAB character ( '09'x&nbsp;&nbsp; '05'x ), but you think it is a white blank.</P></BODY></HTML> Wed, 05 Sep 2012 04:20:25 GMT https://communities.sas.com/t5/SAS-Procedures/Import-txt-file/m-p/111642#M30944 Ksharp 2012-09-05T04:20:25Z