https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669813#M200982 <P>The problem seems to be related to <A href="https://communities.sas.com/t5/SAS-Programming/How-to-import-second-sheet-from-Excel-workbook-in-to-SAS-without/m-p/669265" target="_blank">https://communities.sas.com/t5/SAS-Programming/How-to-import-second-sheet-from-Excel-workbook-in-to-SAS-without/m-p/669265</A>. 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. <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/159">@Tom</a> 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.</P> Thu, 16 Jul 2020 06:34:42 GMT andreas_lds 2020-07-16T06:34:42Z https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669173#M200702 <P>&nbsp;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.&nbsp;</P><P>Thanks in advance..</P> Tue, 14 Jul 2020 14:31:02 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669173#M200702 Padma_stat 2020-07-14T14:31:02Z https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669810#M200981 <P>You want to read the first two sheets regardless of the name?</P> Thu, 16 Jul 2020 05:57:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669810#M200981 ChrisNZ 2020-07-16T05:57:42Z https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669813#M200982 <P>The problem seems to be related to <A href="https://communities.sas.com/t5/SAS-Programming/How-to-import-second-sheet-from-Excel-workbook-in-to-SAS-without/m-p/669265" target="_blank">https://communities.sas.com/t5/SAS-Programming/How-to-import-second-sheet-from-Excel-workbook-in-to-SAS-without/m-p/669265</A>. 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. <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/159">@Tom</a> 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.</P> Thu, 16 Jul 2020 06:34:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-2-sheet-from-Excel-workbook-in-SAS-without/m-p/669813#M200982 andreas_lds 2020-07-16T06:34:42Z