Re: How to import messy txt file with header and data in multiple rows...

Calcite | Level 5

Re: How to import messy txt file with header and data in multiple rows??

Posted 04-18-2020 07:03 PM (633 views)

I am still not able to run VBA code for importing text file with field names in two rows.

1 REPLY 1

Super User

Re: How to import messy txt file with header and data in multiple rows??

Posted 04-18-2020 07:58 PM (621 views) | In reply to ravi12345678

Please post an example of the file you are trying to read. VBA code is usually used by Excel, not SAS. What are you trying to do? Do you have SAS/Add-in for Excel?

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!

Re: How to import messy txt file with header and data in multiple rows??

Re: How to import messy txt file with header and data in multiple rows??

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away