Hi again Cynthia,  Thank you so much for your detailed explanation! I believe I understand now.  I think I was getting confused because I had thought users were being encouraged to open the Storm.xlsx file in Excel at the beginning of the demo on using a library to read Excel files, but as I re-watch it, I believe the intention was for users to follow along on screen. I have not succeeded in navigating to the corresponding physical name location in the Windows File Explorer view. Perhaps that's a bit more complicated when your data is stored on a server? But I had no problem progressing through the rest of the lesson. And it looks and sounds like all of the data files that I need are contained in the &PATH variable and I needn't worry! So, I think I'm all good from here.  Thanks again! Marian ... View more

Hi Cynthia,  Thank you so much for your response! I believe I have figured out the NP activity. I think the the np library may not have been showing up because I wasn't hitting the 'refresh' button in the server window.  However, I'm still a bit unclear on how to access the Excel files.  I saved the course folder on my C drive. So, when I go to my C drive, open EPGIV2_EG, and then open the the 'demos' sub-folder, I see only 29 files all with a .sas extension.  Should I be seeing the xlsx and csv files in this folder too? When I run the pg1v2_eg program (including the PROC CONTENTS step), I see from the Physical Name entry in my Results window that my data is saved in what looks like the work directory of my organization's SAS server. When I expand the work directory in the server window, I see that 24 data sets appear to be saved here.  Does that sound right to you? Many thanks! Marian ... View more

Hi there,  I'm having this same problem regarding creating the np library. I am using SAS Enterprise Guide.  I used the following code:  libname np xlsx "&path/np_info.xlsx"; My log indicates that the Libref np was successfully assigned. The 'Physical Name' location appears to reference the work drive on my organization's server. But I do not see 'np' in the list of libraries that appear in my work drive.  Also, I do not see any xlsx type files in my course folder.  Any help you could provide would be greatly appreciated! Thank you in advance.  ... View more