Proc reoort - how to make icons

mmea — Mon, 21 Dec 2020 11:42:39 GMT

Hi.

I have this code for a proc report

And the format for a check mark symbol do not show in the output ?

options mprint;

Proc format;
value pctf
. =  ''
low-<0.1 = 'X'
0.1-high = '(*ESC*){unicode "2713"x}'
;
value colorf
. =  white
low-<0.1 = lightmoderatered
0.1-high = lightblue
;
run;
%macro many_col;
    proc sql noprint;
        select count(distinct dato) into :ncols from pdf1;
    quit;
    %put &=ncols;
	proc report data=pdf1 style(header) = {background = STEEL color = white};
	    columns region teststed dato,ventetid;
	    define Region/group style(header) = {background = STEEL color = white font_weight=bold font_face=calibri} style(column) = {background = STEEL color = white font_weight=bold font_face=calibri};
	    define teststed/group style(header) = {background = STEEL color = white font_weight=bold font_face=calibri} style(column) = {background = STEEL color = white font_face=calibri};
	    define dato/across order=internal format= ddmmyyd10. style(header) = {background = STEEL color = white font_weight=bold font_face=calibri};
	    define ventetid/sum format=pctf5.'';
	    compute ventetid;
	          %do i=1 %to &ncols;
	               call define("_c%eval(&i+2)_",'style','style={background=colorf. color=black font_face=calibri}');
	          %end;

	      endcompute;
	run;
%mend;

%many_col

Re: Proc reoort - how to make icons

Cynthia_sas — Mon, 21 Dec 2020 17:01:54 GMT

Hi:

What is your destination of interest? RTF, PDF, HTML, EXCEL? You don't show any ODS statements, so it is only a guess that you might want PDF based on the dataset name.

This works for me in HTML, using a simple format specification since you're using the glyph (the checkmark) and other characters for the formatted value and then a DEFINE statement style override to change the background:

Cynthia

topic Re: Proc reoort - how to make icons in New SAS User

Proc reoort - how to make icons

Re: Proc reoort - how to make icons