topic Re: Proc report - colors do not show in New SAS User

Proc report - colors do not show

mmea — Sun, 20 Dec 2020 18:59:02 GMT

Hi.

I have the following code for a proc report.

I have stated that I want some colors, but they do not show in the expected output.

Also I have shown the ouput below - I want to remove the row with the "ventetid" labels - is that possible?

%macro many_col;
    proc sql noprint;
        select distinct dato into :ncols from pdf1;
    quit;
proc format;
    value pctf .=' ' low-<0.1='<10%' 0.1-high='>10%';
    value colorf .=white low-<0.1=lightmoderatered 0.1-high=Steel;
run;
proc report data=pdf1;
    columns region teststed dato, ventetid;
    define region/group;
    define teststed/group;
    define dato/across order=internal format= ddmmyyd10.;
    define ventetid/sum format=pctf5.;
    compute ventetid;
          %do i=1 %to &ncols;
               call define("_c%eval(&i+2)_",'style','style={background=colorf.}');
          %end;
      endcompute;
	  
run;
%mend;

%many_col

Also is it possible in the proc report code to divide the variable "teststed" up in two other groups that will be based on the observations under "teststed" - so e.g. if "teststed" includes something with XXXX then put it in under a new label called "EXAMPLE" etc. So basically under each "region" i want two groups of variables with matching observations.

hope it makes sense 🙂

Re: Proc report - colors do not show

PaigeMiller — Sun, 20 Dec 2020 19:30:19 GMT

There's no need to put this in a new thread, when it is truly a continuation of the other thread. MODERATORS, please merge this with the other thread.

Re: Proc report - colors do not show

Ksharp — Mon, 21 Dec 2020 12:26:06 GMT

Include style in proc format.

proc format;
    value pctf 
      .=' ~S={background=white}' 
     low-<0.1='~S={background=lightmoderatered } <10%' 
      0.1-high='~S={background=green } >10%';
run;
ods escapechar='~';
proc report data=pdf1 nowd;
    columns region teststed dato, ventetid;
    define region/group;
    define teststed/group;
    define dato/across order=internal format= ddmmyyd10.;
    define ventetid/sum format=pctf60.;  
run;

Re: Proc report - colors do not show

Cynthia_sas — Mon, 21 Dec 2020 16:52:56 GMT

Hi:

I do not believe this requires a SAS macro program or CALL DEFINE or using ODS ESCAPECHAR. This works for me with a simple format, specified correctly and a single style override in the DEFINE statement for HEIGHT and WEIGHT:

Hope this gives you some idea of the most straightforward way to use a format and a style override with PROC REPORT to color cells.

Cynthia