My code is: ODS listing close; ODS PDF FILE = "Report.pdf" Style = Styles.journal; ODS escapechar='~'; options orientation = landscape NoDate NoNumber; title; proc report data = Report&Num.b nowd spanrows Style(report)={font_size=0.3 font_face=arial background=white just=center frame=void rules=groups cellpadding=1pt cellspacing=1pt height=0.2in} Style(header)={font_size=0.3 font_face=arial background=white just=center} Style(column)={font_size=0.3 font_face=arial background=white just=center}; column CPN VINT (&Str1. ('Loan Balance' llbc mlbc hlbc) genc lficoc ('LTV' h85c h95c h100c cqc crc) ('Servicer' boac citic jpmc wellsc quickc) invc jumboc) (&Str2. ('Loan Balance' llbd mlbd hlbd) gend lficod ('LTV' h85d h95d h100d cqd crd) ('Servicer' boad citid jpmd wellsd quickd) invd jumbod); define cpn / group format=3.1; define vint / order descending; define llbc / sum format=FMTLLBC.; define mlbc / sum format=FMTMLBC.; define hlbc / sum format=FMTHLBC.; define genc / sum format=FMTGENC.; define lficoc / sum format=FMTLFICOC.; define h85c / sum format=FMTH85C.; define h95c / sum format=FMTH95C.; define h100c / sum format=FMTH100C.; define cqc / sum format=FMTCQC.; define crc / sum format=FMTCRC.; define boac / sum format=FMTBOAC.; define citic / sum format=FMTCITIC.; define jpmc / sum format=FMTJPMC.; define wellsc / sum format=FMTWELLSC.; define quickc / sum format=FMTQUICKC.; define invc / sum format=FMTINVC.; define jumboc / sum format=FMTJUMBOC.; define llbd / sum format=FMTLLBD.; define mlbd / sum format=FMTMLBD.; define hlbd / sum format=FMTHLBD.; define gend / sum format=FMTGEND.; define lficod / sum format=FMTLFICOD.; define h85d / sum format=FMTH85D.; define h95d / sum format=FMTH95D.; define h100d / sum format=FMTH100D.; define cqd / sum format=FMTCQD.; define crd / sum format=FMTCRD.; define boad / sum format=FMTBOAD.; define citid / sum format=FMTCITID.; define jpmd / sum format=FMTJPMD.; define wellsd / sum format=FMTWELLSD.; define quickd / sum format=FMTQUICKD.; define invd / sum format=FMTINVD.; define jumbod / sum format=FMTJUMBOD.; compute before / Style={font_size=0.3 background=lightgray just=left}; line 'FNMA 30-YEAR'; endcomp; compute after cpn / Style={height=0.1in just=center}; line ' '; endcomp; run; FOOTNOTE J=CENTER "Page ~{thispage} of ~{lastpage}"; ODS PDF CLOSE; ODS listing; Sorry I can not provide the data since it is confidential. I want vertical line after vint, hlbc, genc, lficoc, crc, quickc, jumboc, hlbd, gend, lficod, crd, quickd. For horizontal, I can live with my current method to leave space after cpn. Thanks. Jian
... View more