Friday, 7 February 2020

Apply conditional color fomating on SAS output

Below expression can be used to apply color formatting in SAS


case 
when <<root.Order Book Total2>> < 0
then "<font color='red'>"!! PUT(<<root.Order Book Total2>>,24.2) !!"</font>"


when <<root.Order Book Total2>> <> 0 and <<DTMT_INY_INV_BACKLOG_WIP_BT300.CONTRACT_EXPI_DATE>> <today()
then "<font color='red'>"!! PUT(<<root.Order Book Total2>>,24.2) !!"</font>"


else PUT(<<root.Order Book Total2>>,24.2)

end

1 comment:

  1. If you're looking to lose kilograms then you absolutely need to jump on this totally brand new personalized keto diet.

    To create this keto diet service, certified nutritionists, fitness trainers, and professional cooks united to develop keto meal plans that are efficient, suitable, cost-efficient, and delightful.

    From their grand opening in early 2019, 1000's of clients have already remodeled their body and health with the benefits a proper keto diet can offer.

    Speaking of benefits: in this link, you'll discover eight scientifically-tested ones offered by the keto diet.

    ReplyDelete