Conditionally formatting a column using another column in PROC TABULATE

[JET_PANGAN]

Hi,

Using the PROC Tabulate, I'm trying to format the field in the VAR statement using the values in CLASSLEV variable. Unfortunately, it does not work. The format in the VAR statement is dependent on the values in the CLASS variables.

Any help is appreciated. Thanks.

[andreas_lds]

Please post code and log in the windows appearing when using {i}- or running-man-icon. Test-data, posted as data-step using datalines statement, is useful, too.

[JET_PANGAN]

I'm experimenting if the code below works. I attached the sample data.

/* START OF SAS CODE */

proc format;
value measure_fmt
1 = comma32.
OTHER = comma32.2
;
run;

proc tabulate data=WORK.sample_data;
class F1 F2 F3 F4 SEQ_NO;
classlev F4 / style={Format=measure_fmt.};
var NOACCT;
table
/* Row Labels */
SEQ_NO,
/* Column Labels */
F1=" "*F2=" "*F3=" "*F4={LABEL=" "}*NOACCT=" "*SUM=" "*{STYLE=<PARENT>};
RUN;

/* END OF SAS CODE */

[andreas_lds]

SAS-Formats are applied by using the format-statement, not the style option.

So adding

format F4 measure_fmt.;

should solve the issue.