topic How to find worksheet names of an excel file? in SAS Programming

How to find worksheet names of an excel file?

inavjots — Fri, 03 Jul 2020 20:15:27 GMT

Re: How to find worksheet names of an excel file?

Reeza — Fri, 03 Jul 2020 20:48:28 GMT

Assign a libname to the Excel workbook and use PROC CONTENTS.

*This code will create a libname reference to an Excel file and list all Sheets in the results window;
libname sample xlsx 'C:\Temp\Sample_v2.xlsx'; *your statement will depend on your OS/Excel version;

proc contents data=sample._all_;
run;

*copy all worksheets to work library;
proc copy in=sample out=work;
run;

Re: How to find worksheet names of an excel file?

inavjots — Fri, 10 Jul 2020 16:43:32 GMT

libname sample xlsx '/folders/myfolders/EPG194/data/storm.xlsx';
proc contents data=sample._all_;
run;
proc copy in=sample out=work;
run;

It keeps loading. Is there something wrong?

Re: How to find worksheet names of an excel file?

Reeza — Fri, 10 Jul 2020 17:44:33 GMT

What do you mean it keeps loading?
Which step is it having issues with? Run each section (libname, proc contents, proc copy) separately and see exactly which one is problematic.