It works thank you! I'm just wondering why in the demonstration video she used computer file path (S drive) and it worked every time. ... View more

I use UE, but it's capable of reading excel files anywhere in your computer right? I have tried other excel files which are store somewhere else, the same problem happened. ... View more

Hi @ed_sas_member    I have finished the setup before and I even went back to go through it again.   This is my code options validvarname=v7; libname NP xlsx "F:\SAS\myfolders\coursedata\EPG194\data\np_info.xlsx"; and here is the log   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 options validvarname=v7; 74 libname NP xlsx "F:\SAS\myfolders\coursedata\EPG194\data\np_info.xlsx"; NOTE: Libref NP was successfully assigned as follows: Engine: XLSX Physical Name: F:\SAS\myfolders\coursedata\EPG194\data\np_info.xlsx 75 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 Thank you   ... View more