04-12-2017 07:39 AM
I have a .xlsx file which contains the string "X&Y" in a cell. I read it into SAS using the following code:
libname x xlsx "%sysfunc(pathname(work))\pvsds2.xlsx";
set x.'Sheet1'n ;
In the dataset new, the value appears as "X&Y". Am I doing something wrong, or is the XLSX libname engine failing to properly handle the XML in which the XLSX file is encoded?
I am using Enterprise Guide 7.13 on SAS 9.4 on Linux.
04-12-2017 07:50 AM
04-12-2017 07:51 AM
You are reading the XLSX from your WORK directory so I assume you've created this XLSX with SAS. If so then how do you know that the & encoding happens when you read the sheet and doesn't already get written this way to the sheet in an earlier step?
04-12-2017 08:05 AM