topic Re: Call define using conditionally in proc report in SAS Programming

Call define using conditionally in proc report

keen_sas — Tue, 25 May 2021 21:06:13 GMT

Hi All ,

I have a variable and this variable is printed using proc report. Using call define to highlight the particular value of the entire string. But call define is highlighting the entire observation instead of particular string. From the below example I have a string "I know SAS programming". In this string i need to highlight only the SAS keyword and this word is present in another variable to differentiate this in the original string. Call define is not allowing to highlight particular keyword in the string. Any suggestion/alternative to highlight only a specific word in the string as

data compare;
length str1 $64;
str='I know SAS programming';
str1='SAS*';
output;
str='Python programming ac';
str1='Python*';
output;
str ='SAS and R programming' ;
str1='SAS and R*';
output;
run;

Required output: Highlighting only the specified keywords from another variable

Str1	Str2
SAS*	I know SAS programming
Python*	Python programming
SAS and R*	SAS and R programming

Re: Call define using conditionally in proc report

ballardw — Tue, 25 May 2021 21:12:30 GMT

You should show what you have tried in code and provide some actual example data.

You are going to have to break the string apart so style elements can be supplied to just part of the string and may not be a trivial activity depending on the actual values you want highlighted.

Re: Call define using conditionally in proc report

jimbarbour — Tue, 25 May 2021 22:03:15 GMT

@keen_sas,

Please take a look at this post: https://communities.sas.com/t5/ODS-and-Base-Reporting/Highlight-specific-text-within-a-cell-from-proc-report/td-p/554361

I think that post explains how to do just what you're asking.

Jim