ODS _ALL_ CLOSE; ODS LISTING CLOSE; ODS HTML CLOSE; ODS NORESULTS; OPTIONS ORIENTATION=PORTRAIT NOCENTER NODATE NONUMBER TOPMARGIN=".5IN" BOTTOMMARGIN=".5IN" LEFTMARGIN=".5IN" RIGHTMARGIN=".5IN"; %LET RSTR = %STR( ); %LET TSTR = %SYSFUNC(REPEAT(&RSTR,50)); ODS ESCAPECHAR='^'; OPTIONS NOBYLINE; TITLE1 JUSTIFY=CENTER BOLD HEIGHT=12PT FONT="Arial" "DIG Sales"; TITLE2 " "; TITLE3 JUSTIFY=LEFT HEIGHT=9PT FONT=Arial "Customer Number: #BYVAL1" JUSTIFY=CENTER "Customer Name: #BYVAL2" JUSTIFY=RIGHT "Region: #BYVAL3"; TITLE4 " "; TITLE5 "^{style[bordertopwidth=2px bordertopcolor=black] &tstr}"; ODS PDF FILE="%sysfunc(pathname(project))\&FILENAME Report (&rundate).PDF" STYLE=JOURNAL NOTOC BOOKMARKGEN=NO BOOKMARKLIST=NONE; PROC REPORT DATA=FINALDATASET NOWD HEADLINE HEADSKIP MISSING ps=43 ls=108; COLUMN NUMBER_OF_ITEMS ITEMS_COST SALES_TAX TOTAL_COST; BY Customer_Number Customer_Name Region NOTSORTED; DEFINE NUMBER_OF_ITEMS / DISPLAY 'NUMBER OF ITEMS' STYLE(COLUMN)={JUST=LEFT}; DEFINE ITEMS_COST / DISPLAY 'ITEM COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; DEFINE SALES_TAX / DISPLAY 'SALES TAX' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; DEFINE TOTAL_COST / DISPLAY 'TOTAL COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; RUN; TITLE1; TITLE2; TITLE3; TITLE4; TITLE5; TITLE6 JUSTIFY=LEFT HEIGHT=9PT FONT=Arial "Grand Total"; TITLE7 " "; PROC REPORT DATA=FINALDATASET1 NOWD HEADLINE HEADSKIP MISSING ps=43 ls=108; COLUMN NUMBER_OF_ITEMS ITEMS_COST SALES_TAX TOTAL_COST; DEFINE NUMBER_OF_ITEMS / DISPLAY 'NUMBER OF ITEMS' STYLE(COLUMN)={JUST=LEFT}; DEFINE ITEMS_COST / DISPLAY 'ITEM COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; DEFINE SALES_TAX / DISPLAY 'SALES TAX' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; DEFINE TOTAL_COST / DISPLAY 'TOTAL COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={JUST=RIGHT}; RUN; QUIT; ODS PDF CLOSE; ODS HTML CLOSE;