topic highlighting the report in SAS Programming

highlighting the report

ram_adhikari_jacks_sdstate_edu — Sun, 02 Dec 2012 04:11:42 GMT

Hi Everyone,

Could you help me resolve this problem please!

I have this data set

name x1 x2

john 23 12

jenny 54 10

carol 21 11

amber 56 8

1.highlight x1 if x2 is greater than 10

2.the out put should contain only name and x1 (i.e x2 has to be removed).

3.I want the report in RTF file

Thanks for your help.

Ram Adhikari

Robert_Bardos — Sun, 02 Dec 2012 09:02:35 GMT

Tip 1: GIYF (google is your friend) search for "sas proc report conditional highlighting"

Tip 2: download and study Cynthia Zender's presentation available from e.g.

Other hints:

ODS RTF
PROC REPORT
- Column order matters for COMPUTE statements ('name x2 x1')
- look up PROC REPORT's DEFINE statement and its NOPRINT option (your 'x2' variable)
- STYLE option with COMPUTE

Hope this helps getting you started

Robert

Scott_C_Moore — Tue, 11 Dec 2012 14:50:08 GMT

This should get you what you want.

data names;

input name $ x1 x2;

cards;

john 23 12

jenny 54 10

carol 21 11

amber 56 8

;

run;

ods rtf file='myfile.rtf';

proc report data=names nowd;

column name x2 x1;

define name / display;

define x2 / display noprint;

define x1 / display;

compute x1;

if x2 gt 10 then

call define (_col_,'style','style={background=red});

endcomp;

run;

ods rtf close;