Export to excel with mixed format in one column

i_Van — Wed, 22 Sep 2021 09:09:22 GMT

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.

Re: Export to excel with mixed format in one column

Patrick — Wed, 22 Sep 2021 09:37:41 GMT

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.

topic Re: Export to excel with mixed format in one column in SAS Programming

Export to excel with mixed format in one column

Re: Export to excel with mixed format in one column