topic Re: libname in SAS Programming

libname

HishamSharrouf — Tue, 28 May 2019 18:13:52 GMT

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.

Re: libname

Tom — Tue, 28 May 2019 18:27:21 GMT

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

Re: libname

Cynthia_sas — Tue, 28 May 2019 18:34:30 GMT

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

Re: libname

HishamSharrouf — Tue, 28 May 2019 18:57:13 GMT

thank you it works.

Re: libname

Reeza — Tue, 28 May 2019 19:27:58 GMT

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