DATA Step, Macro, Functions and more

determining dlm for PROC IMPORT of a txt file

Accepted Solution Solved
Reply
Super Contributor
Posts: 268
Accepted Solution

determining dlm for PROC IMPORT of a txt file

Here is the first obs of a txt file I need to import. I can't get the correct delimiter.  some vars have been starred out for privacy reasons.

 

SCSchool District of*******         W******* High     007            ******* ******  *******          1018****F9202120374                    09  NNNNNN    00000000  NNNNNNNNNNNNNNNNNNN                                                 400                                                                                                                                                 3021813113093082423102891.91.01.81.81.91.51.81.7X X X X X XXXX     X     X     X                     342262228134336286329289334282273211327293304274                                                                                                                                                                                     0030116                                                            990015090570   990015090638   990015090598   990015090622                                                               OnlineOnlineOnlineOnlineKB                                                              000000011001000110      101000010000100100000001  


Accepted Solutions
Solution
‎08-23-2016 01:49 PM
Super User
Posts: 17,819

Re: determining dlm for PROC IMPORT of a txt file

Its hard to see with that data you posted, but it almost looks like it's a fixed file format, ie no delimiter?

 

If you're sure you have a delimiter look at displaying your text with a HEX format to see the delimiter.

View solution in original post


All Replies
Solution
‎08-23-2016 01:49 PM
Super User
Posts: 17,819

Re: determining dlm for PROC IMPORT of a txt file

Its hard to see with that data you posted, but it almost looks like it's a fixed file format, ie no delimiter?

 

If you're sure you have a delimiter look at displaying your text with a HEX format to see the delimiter.

Super Contributor
Posts: 268

Re: determining dlm for PROC IMPORT of a txt file

I got ahead of myself.  It is a fixed width file.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 224 views
  • 2 likes
  • 2 in conversation