DATA Step, Macro, Functions and more

Access Excel file in UE

Reply
Contributor s_m
Contributor
Posts: 22

Access Excel file in UE

[ Edited ]

I am using SAS Studio (SAS University Edition)

I started the new session but error is still the same.

I am unable to assign a libref through libname statement.

 

libname libsas "/folders/myshortcuts/s2/";
data work.out;
set libsas.abc;

run;

 

ERROR:

File LIBSAS.ABC.DATA does not exist

 

abc.xlsx data is physical present under S2 and is visible in myshorts in sas studio.Please refe the screenshot attached.


error_screenshot2.png
Super User
Posts: 5,438

Re: sas

Libname without any additional options works only for SAS data sets, not for non-SAS file formats.

http://support.sas.com/software/products/university-edition/faq/SAS_accessdata_Excel.htm

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 114 views
  • 0 likes
  • 2 in conversation