https://communities.sas.com/t5/SAS-Programming/Import-Excel-with-multiple-sheets/m-p/815808#M321983 <P>I normally do it in a way similar to this macro :</P> <P>&nbsp;</P> <P>PharmaSUG2011 - Paper CC10<BR />A Recursive SAS Macro to Automate Importing Multiple Excel Worksheets into SAS Data Sets<BR />Wenyu Hu, Merck Sharp &amp; Dohme Corp., Upper Gwynedd, PA<BR />Liping Zhang, Merck Sharp &amp; Dohme Corp., Upper Gwynedd, PA</P> <P><A href="https://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf" target="_blank">https://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf</A></P> <P>&nbsp;</P> <P>Cheers,</P> <P>Koen</P> Tue, 31 May 2022 10:56:58 GMT sbxkoenk 2022-05-31T10:56:58Z https://communities.sas.com/t5/SAS-Programming/Import-Excel-with-multiple-sheets/m-p/815782#M321978 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 Tue, 31 May 2022 07:46:15 GMT https://communities.sas.com/t5/SAS-Programming/Import-Excel-with-multiple-sheets/m-p/815782#M321978 aloou 2022-05-31T07:46:15Z https://communities.sas.com/t5/SAS-Programming/Import-Excel-with-multiple-sheets/m-p/815808#M321983 <P>I normally do it in a way similar to this macro :</P> <P>&nbsp;</P> <P>PharmaSUG2011 - Paper CC10<BR />A Recursive SAS Macro to Automate Importing Multiple Excel Worksheets into SAS Data Sets<BR />Wenyu Hu, Merck Sharp &amp; Dohme Corp., Upper Gwynedd, PA<BR />Liping Zhang, Merck Sharp &amp; Dohme Corp., Upper Gwynedd, PA</P> <P><A href="https://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf" target="_blank">https://www.pharmasug.org/proceedings/2011/CC/PharmaSUG-2011-CC10.pdf</A></P> <P>&nbsp;</P> <P>Cheers,</P> <P>Koen</P> Tue, 31 May 2022 10:56:58 GMT https://communities.sas.com/t5/SAS-Programming/Import-Excel-with-multiple-sheets/m-p/815808#M321983 sbxkoenk 2022-05-31T10:56:58Z