Version 9.4 (TS1M3) Windows 10 64os   Hello:  The output from prg. gives me 2 graphs . One is sgplot.png and the 2nd is ods html file.png. I am thinking that I should be just getting one graph. Not sure why 2 graphs are being produces. I would like to keep only the html file and I would like not to have to  use the delete key for the other.   Thanks for you help.     ods listing close ; ods graphics on / width = 6.4 in height = 4.8 in imagefmt = png imagemap = on border = no ; ods html file = "ChgDIABPvsbaseDia-base.png" style = journal path = 'C:\ProjectName\sasout\png\'  image_dpi = 96 ; Title1 font = 'Arial' H = 1.5 j=c "Figure 2.4 " ; Title2 font = 'Arial' H = 1.5 j=c "Test 1" ; Title3 font='Arial' H = 1.5 j=c "Change vs. Base" ; proc sgplot data = ad2A noautolegend ; where avisitn = -1 ; scatter y = chgdia x = basedia / markerattrs=(symbol=circlefilled size = 4 pt color = blue) ; yaxis label = "Chg. Diastolic BP (mmHg) " values = (-20 to 20 by 10 ) ; xaxis label = "Baseline Diastolic BP (mmHg)" values = (60 to 100 by 10) ; run ; ods graphics off ; ods listing ;   Log output: 4120 ods graphics off ; 4121 4122  4123 ods listing close ; 4124 ods graphics on / 4125 width = 6.4 in 4126 height = 4.8 in 4127 imagefmt = png 4128 imagemap = on 4129 border = no 4130 ; 4131 ods html file = "ChgDiaBPvsbasedia-wk12.png"  The SAS System 4132 style = journal 4133 path = 'C:\Projects\sasout\png\' 4134 image_dpi = 96 ; NOTE: Writing HTML Body file: ChgDiaBPvsbasedia-wk12.png 4135 4136 Title1 font = 'Arial' H = 1.5 j=c "Figure 2.6 " ; 4137 Title2 font = 'Arial' H = 1.5 j=c " Test1" ; 4138 Title3 font='Arial' H = 1.5 j=c "Change Diastolic Mean BP vs. Base BP at Week 12" ; 4139 proc sgplot data = ad2A noautolegend ; 4140 where avisitn = 16 ; 4141 scatter y = chgdia x = basedia / 4142 markerattrs=(symbol=circlefilled size = 4 pt color = blue) ; 4143 yaxis label = "Chg. Diastolic BP (mmHg) " values = (-20 to 20 by 10 ) ; 4144 xaxis label = "Baseline Dialstolic BP (mmHg)" values = (60 to 100 by 10) ; 4145 4146 run ; NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.26 seconds cpu time 0.06 seconds NOTE: There were 109 observations read from the data set WORK.ADZA2A. WHERE avisitn=16; 4147 ods graphics off ; ... View more

Hello ; My problem is that the data string that I would like to put into a cell in excel is getting truncated. I have tried breaking the string up and using macro variables. But the complete string does not show up in the cell in excel,. The max length that I can generate is around 162 characters. I am sure that I am over looking something, but I am not sure what. Thank you for your help. options mprint mlogic symbolgen msglevel=i orientation = landscape             nonumber nodate nofmterr ls=max lrecl=max ; This code goes to the proc report. Bring in the data etc. if name = "&name1  " then do ; col3 = "&length1  " ; col4 = "&formatB1  "; col5 = "&CTerm1"  ; end ; if col6 = "Long text sting goes here" : end ; ods tagsets.EXcelXP options (sheet_name="&dsnme"                          frozen_headers='1'                          autofit_height = 'yes')   file= "c:\sriprojects\&prjname\define_output\&dsnme..xml"   style=minimal ;              proc report data = &dsnme.E headline headskip  split='|' missing                   style(header)=[backgroundcolor=white  ];    column  name label TypeC col3 col4 col5 col6 col7 col8 varnum  ; define varnum / order=data noprint ; define name   / display 'Variable Name'      format= $20.   STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];   define label  / display 'Variable Label'     format= $60.   STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];   define typeC  / display 'Type'               format= $10.   STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ]; define col3   / display 'Length'             format= $10.   STYLE(column)=[cellwidth=100 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];   define col4   / display 'Format '            format= $100.  STYLE(column)=[cellwidth=100 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ]; define col5   / display 'Controlled Terms '  format= $100.  STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];   define col6   / display 'Origin'             format= $100.  STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];  define col7   / display 'Role'               format= $100.  STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ]; define col8   / display 'Comments'           format= $100.  STYLE(column)=[cellwidth=175 just=left vjust=top] style(header)=[font_weight=bold just=left vjust=top ];   run ; ods tagsets.EXcelXP close; ods listing ; ... View more

Hello; Could anyone tell me the difference between bodytitle and bodytitle_aux. With bodytitle_aux j=c  etc will work in my title statement. With bodytitle it does not. Did bodytitle change as ODS RTF has become improved. Thanks JStory ... View more