I have Excel workbook with multiple sheets , I need to read second sheet in to SAS without mentioning sheet name. Why because I don't know what is the exact sheet name at second sheet in the excel workbook. I have tried two methods 1. Proc impot method ( it need sheet name must) 2. Libname method (it reads all sheets from Excel workbook) Can any suggest to import only second sheet from Excel workbook. Thanks in advance..
... View more