BookmarkSubscribeRSS Feed
EdithBratt
Calcite | Level 5

Hi everyone,

 

I'm taking part in SAS Programming 1 course and the first issue that I see is that the autoexec regarding the import of the data for the entire course goes in error when I try to use the libname - XLSX engine. I went through a lot of similar topics but no solutions are working.

 

In particular, I'm using SAS Enterprise Guide 7.1 and when I code :

 

libname NP XLSX "&path\np_info.xlsx" ;

 

the log returns me that "XLSX engine cannot be found".

 

Running the proc setinit, I have SAS/ACCESS Interface to PC Files still valid.

 

Could you please help me?

 

Thanks,

1 REPLY 1
ketpt42
Quartz | Level 8

When you run:

proc product_status;
run;

Does it show a version information for:

For SAS/ACCESS Interface to PC Files ...

If not, there may be something wrong with the installation.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 788 views
  • 0 likes
  • 2 in conversation