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. 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 2157 views
  • 1 like
  • 2 in conversation