topic Re: proc report concatenate columns while retaining style from each in ODS and Base Reporting

proc report concatenate columns while retaining style from each

Rae_ — Thu, 09 Jan 2020 19:11:56 GMT

I'm trying to concatenate two rows one that has standard format and one is italic but I'd like to retain the formatting of the columns so the first part of the text is standard and the second part is italic. As an example I've used the cars data set to illustrate.

data cars;
set sashelp.cars;
run;

    proc freq data=cars;
    table make*type/list out=c1;
    run;

ods escape char="~";
proc report data=c1 split='^' style=journal;

column make type final count;

define make /display left 'Make' style(column)=[width=10%] ;
define type /left display 'Type' style(column)=[width=10% font_style=italic];
define final /computed left 'Make, ~S={font_style=italic}Type' style(column)=[width=10%] ;
define count/center display "M(SD) ^ or N(%)" style(column)=[width=10%];

compute final /character length=95;
final=cat(trim(make),", ",left(trim(type)));
endcomp;

run;

I'd initially attached this to another thread but haven't gotten any responses so I figured it was best to ask a new question. https://communities.sas.com/t5/ODS-and-Base-Reporting/Concatenate-Variables-in-proc-report/m-p/615819#M23661

Re: proc report concatenate columns while retaining style from each

Cynthia_sas — Fri, 10 Jan 2020 21:10:12 GMT

Hi:

You've got the right idea about needing ODS ESCAPECHAR, but you're using it in the WRONG place. The data values will not automatically use italic from the TYPE column in the COMPUTE block for FINAL. The style in one cell is not going to impact the style in a computed . And ESCAPECHAR is one word (not 2 words as you show).

It wasn't clear to me whether you wanted the HEADER to use 2 different styles or the HEADER and the DATA values. In this output. I did both the HEADER and the DATA/COLUMN values. I used red as the foreground for MAKE just to show how to apply a different style to the MAKE value too. And I switched to the current method for specifying the style formatting your method (~S=) is the original method, which may still work, but doesn't have the same capabilities for nesting as the current method.

Hope this helps,

cynthia

Re: proc report concatenate columns while retaining style from each

Rae_ — Thu, 16 Jan 2020 20:39:55 GMT

This is exactly what I needed! Thanks Cynthia. I only did it in the header to make the point because I couldn't get it to work in the cells. I really appreciate the help!