Export to excel with mixed format in one column

[i_Van]

Hello,

Is it possible to export dataset to excel defining colour filling and excel format for each cell?

The dataset is formed like:

Segment   Name        Value

earnings   local_calc  100

earnings   reported     120

earnings   difference   0.20     (=reported-local / local)

spends .....

But in EXCEL I want:

Segment   Name        Value

earnings   local_calc  100$

earnings   reported     120$

earnings   difference   20%     (=reported-local / local)

spends .....

in EXCEL I want to have format regarded on Name column (if Column = difference then PERCENTN10.1 else DOLLAR10) and highlight differences more than 10% by filling cell yellow.

[Patrick]

You can use Proc Export with styles for this. Do some searching for examples here in this forum and/or via Google. 

Use as search terms something like Proc Report and Conditional Formatting.