Hello there, I am a new user of SAS and now I have a big trouble with converting an excel file to a sas data set. I tried sas studio and 9.4, but not succeed either. For example, I created an excel by hand, called data.xlsx, located at desk.There are 2 worksheet in it, one called tests.xlsx, like the following, and the other called family.xlsx. ID Name RestHR MaxHR RecHR TimeMin TimeSec Tolerance TestDate 2458 Murray, W 72 185 128 12 38 D 8/25/2008 2462 Almers, C 68 171 133 10 5 I 6/26/2008 2501 Bonaventure, T 78 177 139 11 13 I 6/26/2008 Here is my code with studio: libname results xlsx 'C:\Users\linsq\OneDrive\Desktop/data.xlsx'; data stress; set results.'tests$'n; run; However, log shows: NOTE: Libref RESULTS was successfully assigned as follows: ERROR: File RESULTS.'tests$'n.DATA does not exist. With SAS9.4, log shows : ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement. Any suggestions ? Any comments? I really appreciate.
... View more