libname

[HishamSharrouf]

options validvarname=v7;
libname np xlsx "C:\Users\HP\Desktop\SASUniversityEdition\myfolders\EPG194\data\np_info.xlsx";

 should be there are three tables in the NP library: Parks, Species, and Visits  ,

but there nothing.

[Tom]

Show the log. Is SAS really running on a Windows machine?  Is it the same machine that has that file on the C: drive?

[Cynthia_sas · Accepted solution]

Hi:

  If you are using SAS University Edition, then you should NOT be using a C: drive location to read the np_info.xlsx file.

  We always recommend finding the file in the server files and folders pane in SAS Studio and then doing a right-mouse click and choosing Properties. In the Properties window, you should see the location of the file for the LIBNAME statement. It should be something like this:

libname np xlsx "/folders/myfolders/EPG194/data/np_info.xlsx";

Note how there is NOT a Windows path or Windows slashes in the above path. This is the path to the NP_INFO.XLSX workbook on my University Edition installation.

Then you can use PROC CONTENTS to see the structure of what's inside the Workbook:

proc contents data=np._all_ nods;
run;

When I run this code, I see the 3 tables that you listed.

Cynthia

[HishamSharrouf]

thank you it works.

[Reeza]

@HishamSharrouf  if your problem is resolved please mark the question as solved. You can mark Cynthia's solution as correct.