How to read 2 sheet from Excel workbook in SAS without Mentioning Sheet name

[Padma_stat]

 I have many excel workbooks available in one folder, I need to read 2 sheet in each excel workbook without mentioning sheet name , can any one suggest me to read that particular 2 second sheet in the workbook. 

Thanks in advance..

[ChrisNZ]

You want to read the first two sheets regardless of the name?

[andreas_lds]

The problem seems to be related to https://communities.sas.com/t5/SAS-Programming/How-to-import-second-sheet-from-Excel-workbook-in-to-.... You can't import sheets without knowing their name - except for using libname-statement, but this route was excluded by yourself in the mentioned discussion. @Tom suggested a way to retrieve the names of the sheets so that the nth sheet could be read without providing the name. I don't think another way exists - or even should exist - to read sheets.