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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 1011 views
  • 2 likes
  • 2 in conversation