Any idea on how to highlight only column "missing in source" ?
Sorry that i cant put all my code here..
proc format;
value tagging
low - 0 = "lightgreen"
1 - high = "lightred";
run;
title "Summary for SDIS 2";
proc report data = compare_SDIS2 nowd;
column app_sys_code reportable_ind tag;
define app_sys_code / group;
define reportable_ind / group;
define tag / across;
compute tag;
call define (_col_,"style","STYLE=[BACKGROUND=tagging.]");
endcomp;
run;
This is also my first time using proc report, please let me know also if there's better way to do the content highlights.
Try this:
compute tag;
call define ('_c4_',"style","STYLE=[BACKGROUND=tagging.]");
endcomp;
Try this:
compute tag;
call define ('_c4_',"style","STYLE=[BACKGROUND=tagging.]");
endcomp;
Thanks for the help.
However, why I cant just put a column name like "Missing in source" ?
This is because i may have other column name "Missing in CCRIS Mart".
I wish to write using a column name rather than column number.
"Missing in source" looks like the name of a column to us humans, but in PROC REPORT with ACROSS variables, there is no such column named "Missing in source". The column name in PROC REPORT is _C4_.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.