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_.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.