topic Re: how to read xls file sheet names and keep in one dataset in SAS Programming

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

thanikondharish — Fri, 12 Mar 2021 09:17:06 GMT

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

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

DJongman — Fri, 12 Mar 2021 09:39:52 GMT

Maybe this link will provide the answer:

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

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

thanikondharish — Fri, 12 Mar 2021 09:47:45 GMT

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

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

DJongman — Fri, 12 Mar 2021 13:14:52 GMT

You could try:

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

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

nero-it — Fri, 12 Mar 2021 13:17:18 GMT

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;