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. 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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