topic Use DDE to conditional format a column on excel in Microsoft Integration with SAS

Use DDE to conditional format a column on excel

vt123 — Fri, 21 Jul 2017 16:55:01 GMT

Hi I am trying to include some code with in the Data _null_ to conditional format a column SAS exported excel sheet. I need help with this is there any way to loop through the cells and check for a value and color the cell based on the value

Re: Use DDE to conditional format a column on excel

Reeza — Fri, 21 Jul 2017 17:26:51 GMT

1. Can you apply conditional formatting to the cells in Excel and then export the data to those cells instead? The conditional formatting will follow.

2. Otherwise, as you export the data, you can check the value and apply the back ground colour. This assumes you're using PUT statements to export your data. If you use PROC export this won't work.

Re: Use DDE to conditional format a column on excel

ChrisBrooks — Sun, 23 Jul 2017 01:14:19 GMT

I wouldn't use DDE - it's very old, awkward to work with and I believe no longer supported by Microsoft anyway. There are some better options detailed here using Proc Print, Proc Report etc.

Re: Use DDE to conditional format a column on excel

vt123 — Thu, 27 Jul 2017 20:26:11 GMT

Hi thanks for you suggestions. I ended up moving the SAS code to excel and did the co ditional formatting using VBA

Re: Use DDE to conditional format a column on excel

vt123 — Thu, 27 Jul 2017 20:27:18 GMT

Hi Reeza could you please provide an example of thesecond option that you mentioned. Thanks!

Re: Use DDE to conditional format a column on excel

Reeza — Thu, 27 Jul 2017 20:33:24 GMT

@vt123 wrote:
Hi Reeza could you please provide an example of thesecond option that you mentioned. Thanks!

Google can...
Page 5/Section 6 -Formatting of Excel Worksheet Cells

http://www2.sas.com/proceedings/sugi27/p005-27.pdf