topic Re: Proc Report Set a Column Bold based on another Column in SAS Programming

Proc Report Set a Column Bold based on another Column

anthony28852 — Thu, 24 Mar 2016 07:47:05 GMT

I have a Proc Report that goes like this

Proc Report Data=Table1;

Column A B C;

compute A;

if B eq 0 then call define(_col_,"style","style={font_weight=bold}");

endcomp;

Run;

However, it doesn't work.

The log says that B is uninitialized. Is there a way to solve it? Thanks before.

Re: Proc Report Set a Column Bold based on another Column

Ksharp — Thu, 24 Mar 2016 08:00:47 GMT

proc report is from left to right .


compute A;
---->
compute B;
or
compute C;

Re: Proc Report Set a Column Bold based on another Column

anthony28852 — Thu, 24 Mar 2016 08:06:19 GMT

Sorry, I don't think I get the point. So how do I compute/set variable A based on Variable B? Thanks.

Re: Proc Report Set a Column Bold based on another Column

andreas_lds — Thu, 24 Mar 2016 09:10:19 GMT

proc reports reads the variable from left to right, when computing A, B has no value. You have to clone B:

Proc Report Data=Table1;
  columns B=_B A B C;

  define _b / noprint;

  compute A;
     if _b eq 0 then call define(_col_,"style","style={font_weight=bold}");
  endcomp;
run;

Re: Proc Report Set a Column Bold based on another Column

Ksharp — Thu, 24 Mar 2016 09:13:08 GMT

compute block is calculated from left to right.
So when you compute it at A , SAS can't know the value of B, because B is after A.
Change :
compute A;
---->
compute B;
or
compute C;

Re: Proc Report Set a Column Bold based on another Column

anthony28852 — Thu, 24 Mar 2016 10:02:23 GMT

I try to do like below (re-arranging the column)

Proc Report Data=Table1;

Column B A C;

compute A:

if B eq 0 then call define(_col_,"style","style={font_weight=bold}");

endcomp;

Run;

And still unsuccesful, can you let me know what did I miss out? Thanks.

Re: Proc Report Set a Column Bold based on another Column

Ksharp — Fri, 25 Mar 2016 00:50:20 GMT

You are defining  _COL_ ,so you can only highlight A not B.
Change it as 

compute B:

Re: Proc Report Set a Column Bold based on another Column

Cynthia_sas — Fri, 25 Mar 2016 02:16:45 GMT

Hi: for a concrete example of how PROC REPORT works, review this related posting:

http://communities.sas.com/t5/Base-SAS-Programming/PROC-REPORT-SAS-log-reporting-dataset-variables-are/m-p/258959#U258959

It has some pseudo-code examples of PROC REPORT's left-to-right processing and how a COMPOUND name has to be used for numeric variables.

cynthia