Proc report

deleted_user — Mon, 22 Feb 2010 12:25:30 GMT

Hi,

I would like to make the row lines bold in proc report. can anyone explain how to do this and also i want to color the particular columns in the same report.........

so i want to do these two things in proc report.................

suggest any soln plz

Thanks,

kumar

Re: Proc report

Cynthia_sas — Mon, 22 Feb 2010 15:48:25 GMT

Hi:
It's not clear whether you want ALL the row lines bold or just the SUMMARY line bold or whether you want the row that meets a certain condition (name='William') to be bold. (Same comment applies to the color issue.)

In either case, you need to investigate the use of the STYLE= option -- which in the case of PROC REPORT and a CALL DEFINE statement, allows you to issue a statement something like this in a COMPUTE block:
[pre]
COMPUTE NAME;
if name='William' then
call define(_ROW_,'style','style={font_weight=bold background=yellow}');
ENDCOMP;
[/pre]

Otherwise, if you just wanted the entire AGE column to have a background of yellow, you could do this in a DEFINE statement:
]pre]
DEFINE AGE / sum 'Age' style(column)={background=yellow};
[/pre]

To see what kind of style attributes can be changed, search in the SAS documentation for the topic:
"Style Attributes and Their Values"

To understand more about using STYLE= overrides, these papers contain some good examples:
http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf
http://www2.sas.com/proceedings/sugi28/015-28.pdf

cynthia

topic Proc report in SAS Procedures

Proc report

Re: Proc report