topic Re: Conditionally formatting a column using another column in PROC TABULATE in New SAS User

Conditionally formatting a column using another column in PROC TABULATE

JET_PANGAN — Tue, 19 Feb 2019 07:04:20 GMT

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.

Re: Conditionally formatting a column using another column in PROC TABULATE

andreas_lds — Tue, 19 Feb 2019 07:11:05 GMT

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.

Re: Conditionally formatting a column using another column in PROC TABULATE

JET_PANGAN — Tue, 19 Feb 2019 07:40:05 GMT

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 */

Re: Conditionally formatting a column using another column in PROC TABULATE

andreas_lds — Tue, 19 Feb 2019 08:05:51 GMT

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

So adding

format F4 measure_fmt.;

should solve the issue.