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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

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