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_.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.