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

sas-innovate-white.png

Our biggest data and AI event of the year.

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.

 

Register now!

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