topic Re: Highlight content in Proc report in SAS Programming

Highlight content in Proc report

ChrisWoo — Tue, 10 Sep 2024 09:41:36 GMT

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.

Re: Highlight content in Proc report

PaigeMiller — Tue, 10 Sep 2024 11:11:30 GMT

Try this:

	compute tag;
		call define ('_c4_',"style","STYLE=[BACKGROUND=tagging.]");
	endcomp;

Re: Highlight content in Proc report

ChrisWoo — Tue, 10 Sep 2024 13:19:05 GMT

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.

Re: Highlight content in Proc report

PaigeMiller — Tue, 10 Sep 2024 13:24:59 GMT

"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_.

Re: Highlight content in Proc report

ChrisWoo — Tue, 10 Sep 2024 13:25:23 GMT

i see, thanks for the explanation