I want to attached the report template but I have a difficulty to attach to my post. Here is my code: %include '/opt/sas/Tablespace/mydirectory/SAS/ExcelXP.sas'; libname mylib '/opt/sas/Tablespace/mydirectory/SAS/'; ods path mylib.tmplmst(update) sashelp.tmplmst(read); ods listing close; ods tagsets.ExcelXP path='/opt/sas/Tablespace/mydirectory/' file="PP_Pay_MIS_&mname..xls"; ods tagsets.ExcelXP options(sheet_interval='bygroup' sheet_label='' suppress_bylines='yes' autofit_height='yes' absolute_column_width='4,7.71,7.71,5,5.71,8,8,8,8,5.71,5.71,8,8.71,8.71,8.71,7.71'); proc report data=final nowd headline headskip style(column)={font_size=1.5} style(header)={FONT_WEIGHT =bold font_size=1.5}; where proc_mm=&proc_mm.; by country; COLUMN process_dt p_dt ('Pre Charge-Off' a1 a2 a7 a9 a11 a_total) ('Post Charge-Off' b1 b2 b7 b9 b11 b_total) ab_total realcoamt; define process_dt /group format=mmddyy8. noprint; define p_dt /computed 'Process Date' left style(column)={background=white font_size=1.5}; define a1 /analysis sum format=dollar10. 'Agent OB Payment(Internal Placed)' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define a2 /analysis sum format=dollar10. 'Agent IB Payment(Internal Placed)' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define a7 /analysis sum format=dollar10. 'OCA Collected' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define a9 /analysis sum format=dollar10. 'OCA PMT. Taken by PPE' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define a11 /analysis sum format=dollar10. 'Agent IB PMT on Non-Placed Acct.' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define a_TOTAL /analysis sum format=dollar10. 'Pre-Chgff Total/(Placed Acct. Only)' style(column)={background=lightyellow font_size=1.5 tagattr="$###,###"}; define b1 /analysis sum format=dollar10. 'Agent OB Payment(Internal Placed)' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define b2 /analysis sum format=dollar10. 'Agent IB Payment(Internal Placed)' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define b7 /analysis sum format=dollar10. 'OCA Collected' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define b9 /analysis sum format=dollar10. 'OCA PMT. Taken by PPE' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define b11 /analysis sum format=dollar10. 'Agent IB PMT on Non-Placed Acct.' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define b_total /analysis sum format=dollar10. 'Post-Chgff Total/(Placed Acct. Only)' style(column)={background=lightblue font_size=1.5 tagattr="$###,###"}; define ab_total /analysis sum format=dollar10. 'Grand Total/(Placed Acct. Only)' style(column)={background=pink font_size=1.5 tagattr="$###,###"}; define realcoamt /analysis sum format=dollar10. 'Charge-Off' style(column)={background=orange font_size=1.5 tagattr="$###,###"}; rbreak after / ol summarize; compute p_dt/char length=8; if _break_='_RBREAK_' then p_dt='Total'; else p_dt=put(process_dt,mmddyy8.); endcomp; run; quit; ods tagsets.ExcelXP close;
... View more