04-03-2017 06:43 AM
I want to create an xml file in SAS (9.4), and I want it to include conditional formatting, so when you change a cell value in that xml file, that cell eg changes colour. I.e. I don’t want to define the cell value in SAS, but in Excel (2016). Is this possible? If so, how?
04-03-2017 09:33 AM
04-04-2017 04:24 AM
04-04-2017 09:23 AM - edited 04-04-2017 09:25 AM
it's really odd, but when I look at your sheet, the value of A1 is red and the value of B1 never changes color when I change the value in A1.
Looking at the Excel file itself, it appears that the formula specifies to change A1, not B1.
However, the question for Tech Support will be whether ODS EXCEL (the only destination that creates XLSX files) can insert the necessary XML into the XLSX zip archive, as shown below.
05-03-2018 03:16 PM
For this specific problem, I would look at the following paper (or more accurately poster):
It describes how do create an Excel file from SAS with formatted values.
Excel uses the term conditional formatting, but SAS calls it traffic lighting. It appears that traffic lighting has been around for a while. The SUGI 31 paper I mentioned above was written in 2006. I have yet to try it myself with SAS 9.4.
05-03-2018 06:05 PM