I know this question has already been asked several times, however unfortunately none of the solutions worked for me. I have a xlsx file where I have a sheet called "Data" which has raw data (exported from SAS) and then there are other sheets which calculate values based on the "Data" sheet. I need to update the "Data" sheet every month. I would like to be able to export a SAS dataset to this file so that only the "Data" sheet is replaced and all other sheets in the file remain the same. Previously, I had 64-bit Office 2013 installed onto my computer and I was able to achieve the above by using the below code: PROC EXPORT DATA= work.dataset
OUTFILE= "file_path\file_name.xlsx"
DBMS = excel REPLACE;
SHEET = "Data";
RUN; However, I have now 32-bit Office 2016 installed onto my computer. When I run the above code, I get an error message saying: ERROR: Connect: Class not registered When I change the code so that "DBMS = xlsx", the code runs, but then the entire file is now replaced and only the "Data" sheet remains. I am using SAS 9.3. Thanks for you help in advance!
... View more