I am trying to do several things... 1 I want to underline my first title in Proc Report..... Second a blank line between Title1 and Title2 ... Currently using SAS 9.1.3, and latest excelxp tagset. ods tagsets.ExcelXP style=minimal file = "P:\Analytics\Meta_Partner_Report\chritest.xlm"; ods tagsets.ExcelXP options(default_column_width="20, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10" width_fudge='0.75' EMBEDDED_TITLES = 'yes' AUTOFIT_HEIGHT = 'yes' bordercolor = 'yes' FITTOPAGE = 'yes' orientation = 'landscape' frozen_headers='4' Pages_FitWidth = '1' Pages_FitHeight = '100' sheet_interval='none' sheet_name='PASNAP Frontpage'); * WORKSHEET 1 - FRONTPAGE; title; title1 Underline f='Myriad' h=18pt c=black bc=CXA9CC38 "PA SNAP Report"; title2 f='Myriad' h=18pt bc=CXA9CC38 "PA SNAP Summary of Results by List Source"; proc report nowindows data = Xl_pasnap_frontpage split='*' style(header)=[background=CX152E5F font_face=Myriad font_size=14pt foreground=cxffffff]; column PA_Type Total_Outreach Total_Unique_Outreach Responded SNAP_Initiated SNAP_Submitted Secondary_Submitted PA_SNAP_Submissions_Grand_Total; define PA_Type/"PA SNAP Type"; define Total_Outreach/"Total Outreach"; define Total_Unique_Outreach/"Unique Outreach"; define Responded/"Unique Responses"; define SNAP_Initiated/"Initiated"; define SNAP_Submitted/"Submitted"; define Secondary_Submitted/"Secondary Submissions"; define PA_SNAP_Submissions_Grand_Total/"Project Total Submissions"; run;
... View more