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;