highlighting the report

[ram_adhikari_jacks_sdstate_edu]

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]

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.

         http://www.lexjansen.com/pharmasug/2007/hw/hw03.pdf

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]

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;