Skip to content

Instantly share code, notes, and snippets.

@statgeek

statgeek/SAS_listExcelSheets

Created April 9, 2014 21:55
Show Gist options
  • Save statgeek/10322081 to your computer and use it in GitHub Desktop.
Save statgeek/10322081 to your computer and use it in GitHub Desktop.
Download ZIP
List all Excel sheets in a workbook
Raw
SAS_listExcelSheets
*This code will create a libname reference to an Excel file and list all Sheets in the results window;
libname sample pcfiles path='C:\Temp\Sample_v2.xlsx'; *your statement will depend on your OS/Excel version;
proc contents data=sample._all_;
run;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment