September 2019
Beginner to intermediate
346 pages
7h 35m
English
We can color-code the output based on certain values. This is also known as traffic lighting the data you generate. Remember that, in the following code, we could have used the "low-80" syntax for specifying the least height to have the color red. However, doing so would have also ensured that the Age variable would have been color-coded:
Proc Format;Value Format_Height80-90 ='Red'91-110='Yellow'111-high='Green';ODS Excel File = '/folders/myfolders/Proc_Format.xlsx';Proc Print Data=Class NoObs;Var ClassID Age Height / Style=[Backgroundcolor=Format_Height.];Where Year=2019;Run;ODS Excel Close;
This produces the following output:
Read now
Unlock full access