topic Re: Programming1 Lesson 2: Accessing Data in Programming 1 and 2

Programming1 Lesson 2: Accessing Data

k_fei — Fri, 21 Sep 2018 20:25:35 GMT

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.

Re: Programming1 Lesson 2: Accessing Data

Panagiotis — Fri, 21 Sep 2018 20:32:41 GMT

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

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

- Peter

Re: Programming1 Lesson 2: Accessing Data

k_fei — Fri, 21 Sep 2018 20:39:52 GMT

Yes, you're right. thank you!

Re: Programming1 Lesson 2: Accessing Data

Panagiotis — Fri, 21 Sep 2018 20:41:31 GMT

No problem! Path will get you to the main folder, the /data/ will go inside the data folder where the Excel file is located.

Re: Programming1 Lesson 2: Accessing Data

k_fei — Fri, 21 Sep 2018 20:44:42 GMT

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