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
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.
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.
I got ahead of myself. It is a fixed width file.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.