I have a problem with creating a library to read and access Excel files.    Based on the instruction, I have to first create a library to access and read Excel files. The statements to create the intended library is:   *complete the OPTIONS statement; options validvarname=v7; *complete the LIBNAME statement; libname xlstorm xlsx "s:/workshop/data/storm.xlsx"; Running this gives this message:      1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 *complete the OPTIONS statement; 74 options validvarname=v7; 75 76 *complete the LIBNAME statement; 77 libname xlstorm xlsx "s:/workshop/data/storm.xlsx"; NOTE: Libref XLSTORM was successfully assigned as follows: Engine: XLSX Physical Name: s:/workshop/data/storm.xlsx   Then, I run the full statement: *complete the OPTIONS statement; options validvarname=v7; *complete the LIBNAME statement; libname xlstorm xlsx "s:/workshop/data/storm.xlsx"; *complete the DATA=option to reference the STORM_SUMMARY worksheet; proc contents data=xlstorm.storm_summary; run; *clear the xlstorm library; libname xlstore clear; Opposite to the instructor's result- which is a nice table, mine gives me this message:   78 *complete the DATA=option to reference the STORM_SUMMARY worksheet; 79 proc contents data=xlstorm.storm_summary; ERROR: File XLSTORM.storm_summary.DATA does not exist. 80 run;   NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   NOTE: The SAS System stopped processing this step because of errors. 81 *clear the xlstorm library; 82 libname xlstore clear; WARNING: Libref XLSTORE is not assigned. 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 97     What is wrong with my activity while the library was created/assigned at the first step?   Looking for quick help.    Thanks   ... View more

Hi there,   I am an absolute newbie in programming and in SAS. I am taking an essential e-learning course right now to familiarize myself with the basics.    I created the PG1 library yesterday as it was required by the course. Today, I wanted to write a journal about my learning, but I was stuck in creating a library section. I wanted to provide an example of what I have learned but it did not work. I used both localhost and the SAS Studio server. In both cases, I received errors in my log and I wanted to change the path of PG1 and that showed invalid.    Please help me what is the problem. I want to use this activity as an example of my self-study journal.    Thanks,   Esmat ... View more