08-22-2014 08:39 PM
I have an Excel spreadsheet that has lots attributes/formats such as bolded fonts, color fonts, highlighted cells & etc and I need to keep them. There is one particular column that I need to update/modify based on the SAS dataset. See example below. My code is working fine in a 32 bit system (PC SAS 9.2) and noticed that it doesn't work in a 64 bit system (also in PC SAS 9.2). The MS Office is in 32 bit. I have installed PC Files Server so reading in the Excel data is not an issue. The issue is when I was trying to replace a particular column in Excel. Based on SAS usage note 42151 (Usage Note 42151: PCFILES engine does not support MODIFY in a DATA Step). I'm wondering if there is another option as I don't want to export the entire SAS dataset to Excel and lose all the pre-existing attributes/format as stated above. Any pointer is greatly appreciated.