topic Re: Highlighting top and bottom 10 rows in SAS Procedures

Highlighting top and bottom 10 rows

VarmaSekhar — Fri, 10 Apr 2015 01:58:21 GMT

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

Re: Highlighting top and bottom 10 rows

Ksharp — Fri, 10 Apr 2015 15:25:27 GMT

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

Re: Highlighting top and bottom 10 rows

VarmaSekhar — Sun, 12 Apr 2015 02:44:22 GMT

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.