Help using Base SAS procedures

Highlighting top and bottom 10 rows

Reply
Occasional Contributor
Posts: 7

Highlighting top and bottom 10 rows

Hello All

I have a dataset that I created from my insurance data. At the end, I need to create a pdf document that contains all of my data with highlighting top and bottom 10 rows (entire rows). Can someone help me how I can obtain this?

Thanks

Varma

Super User
Posts: 9,676

Re: Highlighting top and bottom 10 rows

You'd better post it at ODS and Report forum, Cynthia is good at it .

proc sql noprint;
 select count(*) into : n from sashelp.class;
quit;
ods listing close;
ods pdf file='c:\temp\x.pdf' style=sasweb;
proc report data=sashelp.class nowd;
 columns name sex age;
 define name/display;
 compute age;
  n+1;
  if n le 3 or n ge %eval(&n-3) then call define(_row_,'style','style={background=yellow}');
 endcomp;
run;
ods pdf close;
ods listing;

Xia Keshan

Occasional Contributor
Posts: 7

Re: Highlighting top and bottom 10 rows

Thank you so much Xia Keshan. It is exactly what I needed. In the future, I will make sure to post it in the corresponding forums.

Ask a Question
Discussion stats
  • 2 replies
  • 221 views
  • 0 likes
  • 2 in conversation