Reading Excel File to SAS Data - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

Reading Excel File to SAS Data

Posted 12-19-2019 10:19 PM (608 views)

Hi ,

I need help reading multiple excel files at one location and create multiple tables reading all excel files.Please if you can provide me the code

Thanks In Advance,

Kajal

1 REPLY 1

Lapis Lazuli | Level 10

Lapis Lazuli | Level 10

Re: Reading Excel File to SAS Data

Posted 12-19-2019 10:48 PM (586 views) | In reply to kajal_30

You can refer this community post to import all excel files using SAS Macro:

https://communities.sas.com/t5/SAS-Programming/importing-all-excel-files-ina-folder/td-p/12820

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!