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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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