BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
GreggB
Pyrite | Level 9

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  

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

2 REPLIES 2
Reeza
Super User

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.

GreggB
Pyrite | Level 9

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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