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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.