You can create an Import task for every Excel file; the wizard will guide you through this.
Or you copy all your Excel files to the SAS server (either by using the Copy Files task, or an external utility like WinSCP), and write code that assigns a library for every Excel file, after which you can use DICTIONARY.TABLES and DICTIONARY.COLUMNS to extract the metadata.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.