- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-03-2020 04:15 PM
(1307 views)
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
*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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
proc contents data=sample._all_;
run;
proc copy in=sample out=work;
run;
It keeps loading. Is there something wrong?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Which step is it having issues with? Run each section (libname, proc contents, proc copy) separately and see exactly which one is problematic.