https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293507#M61096 <P>I got ahead of myself. &nbsp;It is a fixed width file.</P> Tue, 23 Aug 2016 17:49:19 GMT GreggB 2016-08-23T17:49:19Z https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293443#M61072 <P>Here is the first obs of a txt file I need to import. I can't get the correct delimiter. &nbsp;some vars have been starred out for privacy reasons.</P> <P>&nbsp;</P> <P>SCSchool District of******* &nbsp; &nbsp; &nbsp; &nbsp; W******* High &nbsp; &nbsp; 007 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;******* ****** &nbsp;******* &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1018****F9202120374 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09 &nbsp;NNNNNN &nbsp; &nbsp;00000000 &nbsp;NNNNNNNNNNNNNNNNNNN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3021813113093082423102891.91.01.81.81.91.51.81.7X X X X X XXXX &nbsp; &nbsp; X &nbsp; &nbsp; X &nbsp; &nbsp; X &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 342262228134336286329289334282273211327293304274 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0030116 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;990015090570 &nbsp; 990015090638 &nbsp; 990015090598 &nbsp; 990015090622 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OnlineOnlineOnlineOnlineKB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;000000011001000110 &nbsp; &nbsp; &nbsp;101000010000100100000001 &nbsp;</P> Tue, 23 Aug 2016 14:20:54 GMT https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293443#M61072 GreggB 2016-08-23T14:20:54Z https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293505#M61094 <P>Its hard to see with that data you posted, but it almost looks like it's a fixed file format, ie no delimiter?</P> <P>&nbsp;</P> <P>If you're sure you have a delimiter look at displaying your text with a HEX format to see the delimiter.</P> Tue, 23 Aug 2016 17:47:29 GMT https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293505#M61094 Reeza 2016-08-23T17:47:29Z https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293507#M61096 <P>I got ahead of myself. &nbsp;It is a fixed width file.</P> Tue, 23 Aug 2016 17:49:19 GMT https://communities.sas.com/t5/SAS-Programming/determining-dlm-for-PROC-IMPORT-of-a-txt-file/m-p/293507#M61096 GreggB 2016-08-23T17:49:19Z