@Ficu2019
@Ficu2019 wrote:
Hello there,
Thanks! Yes, it worked! However, what has been puzzling is that the original codes DID work very well until about a couple of weeks ago. That is, the file folder to which the Excel file was imported did not have to be named the same as the library's name. For example, I named the library X for the ease of typing; but, the folder where the Excel resides was meaningful. Any idea why there is this change or was I missing any other info?
Anyway, I found out an alternative by simply creating a permanent SAS dataset without using the libname statement, and it worked, too.
A libname definition that uses the xlsx engine can have any valid libref (like X). The path must point to the actual Excel file and not just the folder that contains the Excel file.
libname <libref> xlsx '<path>/<name of Excel workbook>.xlsx';
data <sastable>;
set <libref>.<sheet name>;
run;
Also important: SAS onDemand for Academics runs under Linux which is case sensitive. Make sure that both path and Excel file name use the exact casing.
... View more