Highlighting part of string value in proc report column

HN2001 — Fri, 10 Nov 2023 15:09:07 GMT

Hi!

I have a proc report table that I'm producing and I need to highlight the first word in the values. Is there a way to code for that in the proc report statement.

Also, if anyone would know how to code something in the middle of the string (ex: 4dr, 2dr) that could be helpful too.

I used a SAS dataset to give a basic example of the code and output.

data audi;

set sashelp.cars;

where make="Audi";

run;

ods listing close;

ods excel file="C:\test.xlsx";

ods excel options(sheet_name="test" sheet_interval="none");

proc odstext;

p "This gives Audi cars" / style=[font_weight=bold font_size=16pt cellwidth=15in];

p " ";

run;

proc report data=audi

style(report)={font_size=12pt}

style(header)={font_size=12pt background = aliceblue}

style(column)={font_size=12pt};

column (make model type);

define make / 'Make of car' display;

define model/'Model of car' display;

define type / 'Type of car' display;

run;

ods excel close;

Re: Highlighting part of string value in proc report column

Cynthia_sas — Fri, 10 Nov 2023 17:38:07 GMT

Hi:

ODS ESCAPECHAR to the rescue. For most ODS destinations, you can use ODS ESCAPECHAR to insert style overrides for pieces of a string. This is easier to do in a DATA step before your reporting step so that you can use the SCAN, SUBSTR and CAT functions to rebuild the string with the ESCAPECHAR overrides.

Here's an example:

This works in ODS HTML and ODS EXCEL, as shown above. I added the colors with the bold, so the changes would stand out in the screen shot. Of course, this does assume that the strings 4dr and 2dr are all you're looking for and that the string is exactly 3 characters long and that by the first word, you meant the first "chunk" of the Model variable up to the first space in the value.

Cynthia

topic Highlighting part of string value in proc report column in SAS Programming

Highlighting part of string value in proc report column

Re: Highlighting part of string value in proc report column