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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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