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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1166 views
  • 1 like
  • 2 in conversation