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;