The SAS Output Delivery System and reporting techniques

column borders

Reply
N/A
Posts: 0

column borders

Using SAS 9.13, ODS to PDF, I want to put a vertical line between certain columns only. For example I want a vertical line between avg_days_denied and the next column, but not between all columns.

Between RULES, FRAMES, BORDERWIDTH, etc., I can't seem to figure out this simple thing.

Thanks!
Lisa

ods listing close;
options pageno=1 missing='';
ODS escapechar='^';
OPTIONS ORIENTATION = landscape;
ODS PDF FILE = "&PDF_FILE" style=sasdocprinter startpage=no BOOKMARKLIST= HIDE BOOKMARKGEN= NO ;
OPTIONS NOCENTER NODATE NONUMBER TOPMARGIN=.25 IN BOTTOMMARGIN=.25 IN RIGHTMARGIN=.25 IN LEFTMARGIN=.25 IN;

PROC REPORT DATA=KEEP.claims_processed_400_10
NOWINDOWS SPLIT="*" STYLE(REPORT)=[JUST=CENTER FRAME=BOX CELLSPACING=0 font_face="Times New Roman"]
STYLE(COLUMN)=[FONT_SIZE=1 CELLSPACING=0 font_face="Times New Roman"]
STYLE(HEADER)=[FONT_SIZE=1 font_face="Times New Roman"]
STYLE(LINES)=[FONT_SIZE=1 font_face="Times New Roman" ]
STYLE(SUMMARY)=[FONT_SIZE=1 font_face="Times New Roman" font_style=roman font_weight = bold];

TITLE1 JUSTIFY=LEFT '^S={preimage="&csmg_standard_logo"}'
JUSTIFY=CENTER font='Times New Roman' height=12pt "&Title1Plan."
JUSTIFY=RIGHT '^S={postimage="&dsi_standard_logo"}';
TITLE2 JUSTIFY=CENTER font='Times New Roman' height=12pt "Adjudicated Claims Summary";
TITLE3 JUSTIFY=CENTER font='Times New Roman' height=12pt "&monthrept";

columns ("Denied" deny_reason_code deny_desc total_denied_reason pct_den avg_days_denied) blank1
("Pended" pend_reason_code pend_desc total_pend_reason pct_pend avg_days_pend) blank2
("Dirty" dirty_reason_code dirty_desc total_dirty_reason pct_dirty avg_days_dirty)
avg_days_denied_all avg_days_pend_all avg_days_dirty_all;

define deny_reason_code /format=$10. 'Code' style=[just=left CONTENTPOSITION= LEFT ];
define deny_desc /format=$30. 'Desc' style=[just=left];
define total_denied_reason /format=comma12.0 'Count' style=[just=right];
define pct_den /format=percent8.1 '% of Total' style=[just=right cellwidth=20mm];
define avg_days_denied/format=6. 'Avg Days' style=[just=right cellwidth=15mm];
define avg_days_denied_all/mean noprint;
define blank1 /computed '' style=[cellwidth=8mm ] ;

define pend_reason_code /format=$10. 'Code' style=[just=left];
define pend_desc /format=$30. 'Desc' style=[just=left];
define total_pend_reason /format=comma12.0 'Count' style=[just=right];
define pct_pend /format=percent8.1 '% of Total' style=[just=right cellwidth=20mm];
define avg_days_pend/format=6. 'Avg Days' style=[just=right cellwidth=15mm];
define avg_days_pend_all/mean noprint;
define blank2 /computed '' style=[cellwidth=8mm];

define dirty_reason_code /format=$10. 'Code' style=[just=left];
define dirty_desc /format=$30. 'Desc' style=[just=left];
define total_dirty_reason /format=comma12.0 'Count' style=[just=right];
define pct_dirty /format=percent8.1 '% of Total' style=[just=right cellwidth=20mm];
define avg_days_dirty/format=6. 'Avg Days' style=[just=right cellwidth=15mm ];
define avg_days_dirty_all/mean noprint;
compute blank1;
blank1=.;
endcomp;

compute blank2;
blank2=.;
endcomp;

compute before _PAGE_ /style=[font_weight=bold];
line ' ';
line 'Top 5 Overall Denied, Pended and Dirty';
endcomp;

rbreak after /summarize skip OL style(summary) = {font_weight = bold font_size = 1 background=ltgray};
compute after;
deny_desc='Total';
avg_days_dirty.sum = avg_days_dirty_all.mean;
avg_days_denied.sum= avg_days_denied_all.mean;
avg_days_pend.sum=avg_days_pend_all.mean;
endcomp;
run;
Occasional Contributor
Posts: 18

Re: column borders

Hi there

As far as I know, this can't be done just using REPORT and ODS. However, using annotate on an otherwise 'blank' GSLIDE, you can do it - see Pete Lund's paper at www2.sas.com/proceedings/sugi31/092-31.pdf

TF
Ask a Question
Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation