BookmarkSubscribeRSS Feed
k_fei
Fluorite | Level 6

I'm using SAS Enterprise version and going to lesson 2 accessing data. I want to do the following

libname np xlsx "&path/np_info.xlsx";
run;

 

The np library is created and it supposes to have 3 tables under that library, but I can't find the tables. I'm wondering there is missing np-info.xlsx file under that path. 

 

Anyone can help me? 

 

Thanks. 

4 REPLIES 4
Panagiotis
SAS Employee

Try adding /data/ between path and the Excel file:

 

libname np xlsx "&path/data/np_info.xlsx";

- Peter

k_fei
Fluorite | Level 6

Yes, you're right. thank you!

Panagiotis
SAS Employee
No problem! Path will get you to the main folder, the /data/ will go inside the data folder where the Excel file is located.
k_fei
Fluorite | Level 6

Got it. I'm a new here. Probably more questions come later. Thanks again. 

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
LIBNAME 101

Follow along as SAS technical trainer Dominique Weatherspoon expertly answers all your questions about SAS Libraries.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3675 views
  • 1 like
  • 2 in conversation