BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ChrisWoo
Obsidian | Level 7

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.

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

Try this:

 

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

View solution in original post

4 REPLIES 4
PaigeMiller
Diamond | Level 26

Try this:

 

	compute tag;
		call define ('_c4_',"style","STYLE=[BACKGROUND=tagging.]");
	endcomp;
--
Paige Miller
ChrisWoo
Obsidian | Level 7

Thanks for the help.

However, why I cant just put a column name like "Missing in source" ?

ChrisWoo_0-1725974100183.png

 

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.

 

ChrisWoo_1-1725974298903.png

 

PaigeMiller
Diamond | Level 26

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

--
Paige Miller
ChrisWoo
Obsidian | Level 7
i see, thanks for the explanation
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1219 views
  • 1 like
  • 2 in conversation