how to read xls file sheet names and keep in one dataset

[thanikondharish]

I have xls file path is 'D:\Parc\file_dump.xls' . In this file I have sheet names so how to read those sheet names

and create one dataset like (sheet names are class,car) . and  how to count no.of sheets.

For ref:

sheet_names

1)class

2)car

[DJongman]

Maybe this link will provide the answer:

https://www.lexjansen.com/nesug/nesug12/cc/cc37.pdf

[thanikondharish]

In the pdf file we are mentioning sheet names dm , mh sheets. but I don't
know sheet names so how to read sheet names

[DJongman]

You could try:

https://communities.sas.com/t5/SAS-Data-Management/Importing-multiple-Excel-sheets/td-p/296480

[nero-it]

libname my excel 'c:\test\nero_example.xls';
data my_sheet(keep=sheet);
set sashelp.vtable(where=(libname eq 'MY'));
sheet=memname;
run;
libname my clear;