Import Excel with multiple sheets

[aloou]

Hello everyone, In SAS VIYA, i would like to import an excel file with multiple sheets. Do you have an idea which option shall i use ? Thank you

[sbxkoenk]

I normally do it in a way similar to this macro :

PharmaSUG2011 - Paper CC10
A Recursive SAS Macro to Automate Importing Multiple Excel Worksheets into SAS Data Sets
Wenyu Hu, Merck Sharp & Dohme Corp., Upper Gwynedd, PA
Liping Zhang, Merck Sharp & Dohme Corp., Upper Gwynedd, PA

https://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf

Cheers,

Koen