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 (577 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 (555 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