Perfect so it looks like everything was set up correctly. From the looks of it you are not pointing to the correct location of the Excel file.
You can see the location of all the SAS tables and additional files (Excel, csv and txt) by typing the code below and checking your log.
%put &=path;
You will cover macro variables in this course, but for now understand that instead of typing in the long location that you are seeing with %put, you can use the &path macro variable to point to that exact location. &path is just storing that string that you saw in your log.
That location is where the STORM.XLSX file resides. So you will want to use the &path macro variable (location of your work library) and the STORM.XLSX file. So try typing this:
OPTIONS VALIDVARNAME=V7;
LIBNAME XLCLASS "&path\storm.xlsx";
PROC CONTENTS DATA=XLCLASS.STORM_SUMMARY;
RUN;
LIBNAME XLCLASS CLEAR;
Let me know if this works!
- Peter
... View more
