Paige, The last reference about DDE and excel is from Guam and Hadden at Nesug2013 "EXCELing in DDE:  Unlock Useful Tools for Processing Excel®  " http://www.lexjansen.com/nesug/nesug13/151_Final_Paper.pdf Inside you have a link to a complete list zip file and also some technics linked to office14         HTH Andre ... View more

Dear Cynthia, X11 is the other word for Xwindows  (through xming or Nx). Our use is together with Sas remote browser that is opening "ods results and help"  in Firefox. When i was preparing the switch between 9.2.3 to 9.3.2  for our linux users, i have observed that the preferences of creating the sashtml file into the work (common to all users) was usefull (button create html + use work folder + use ods graphics pushed) but that the opening of results was prolific  (so we decided to not push the button view results as they are generated). To view a results it is necessary to click (right maintained click) somewhere in the results windows at the level of the new result. OR to refresh the already opened sashtml file under firefox/IE. This avoid a lot of open panes of the browser. Of course we have showed the classical ods sandwich instructions functionning (ods xxx file=, ...; ..; ods xxx close; ) but people here likes this not too much! And they were avid about the ods html path="%sysfunc(pathname (WORK))"; *this avoid any cleaning of created html files !; My question was only about the fact that i really don't see the effect of ods preferences ;   is the Xwindows + RMB  context. I will perhaps  see with the SAS support but it is not really an incident. HTH Andre ... View more

Sassavy, I tried too of course under a french sas 9.3.2 opened in ut8 mode   in W7 32b  in french language reading from a text editor (with correct local writing of your french source). with infile "d:\CA_French_Month.txt" dlm= "|" truncover  encoding="pcoem850"; everything inside sas seems to work but is the accented character real utf8? Ultraedit show me the equivalent of what is visible  in the output sas windows   after a copy                             1     janvier       janv       January                             2     fÚvrier      fÚvr      February                             3     dÚcembre     dÚc       December                             4     ao¹t         ao¹t      August                             5     mars          mars       March                             6     avril         avril      April                             7     mai           mai        May                             8     juin          juin       June                             9     juillet       juil       July                            10     septembre     sept       September                            11     octobre       oct        October                            12     novembre      nov        November                            13     dÚcembre     dÚc       December But i encounter a problem similar to yours with august if i use your code or  this one infile "d:\CA_French_Month.txt" dlm= "|" truncover  encoding="ansi"; in ultraedit i see then after a copy:                        1     janvier      janv                January                         2     février      févr                February                         3     décembre     déc                 December                         4                  août|août|August                         5     mars         mars                March                         6     avril        avril               April                         7     mai          mai                 May                         8     juin         juin                June                         9     juillet      juil                July                        10     septembre    sept                September                        11     octobre      oct                 October                        12     novembre     nov                 November                        13     December     déc|décembre the original data were  without blanks  like ... View more

wcpatton, Read now my comment of the code: the comments of Reeza and Cynthia are welcome. * now with comments  and one apologize about the implicit context; * i was supposing you were with those implit rules     ods graphics on / results drected to the internal browser/ods html 9.3 by default; proc print data=sashelp.class;run; * appearing in the results viwer as html; ods html close; *closing html so that perhaps you want another ods destination; ods preferences; * to be free to restart eventually the ods html in order to produce another html file; ods results=off; * now you said no results viewer : in consequence i close the results viewer; * and you have the possibility to produce listing text results in the OUTPUT windows which is different from the results viewer; ods listing; proc print data=sashelp.class;run; *you see it in the output windows!; ods html path="%sysfunc(pathname (WORK) ) "; * this is the only way to restart producing in the implicit destination  html under 9.3  in the work so that at the end you don't have to delete all the attemps html+png you may have produced as try...  ; * but; ods results=on; * you have to open results again to permit the results viwer to work again; proc print data=sashelp.class;run; * you have seen a new results in html (a new file  in the work) in the results viewer; ods html close; * closing again the results viewer in order to only produce a xls file that will not open in the results viewer through the ods html xls suffix trick; ods results=off; *therefor as my/yours? implicit setting is opening inside the internal viewer i need to close the results  to SILENT producie thepseudo xls file avoiding the opening of the internal results viewer!; ods html file="d:\pseudoexcel.xls" style=minimal; proc print data=sashelp.class;run; ods html close; * did you see something no!; *but you have your excel file; * if your settings (see Cynthia answer) were opening  with firefox or IE   and not in the results viewer  , all that behavior would appear different and the explained logic have to be changed; ods results on; * turn  now the results on again to work again normally    and open your desired destination   : attention  as i don't have close listing it is yet open    like in 9.2.3; /* for me ods results on;  ods noresults ; are the same as ods results=on; ods results=off; UNTIL ANYBODY PROOF ME A SUBTLE DIFFERENCE ; */ Andre ... View more

Analyze this sequence proc print data=sashelp.class;run; ods html close; ods preferences; ods results=off; ods listing; proc print data=sashelp.class;run; ods html path="%sysfunc(pathname (WORK) ) "; ods results=on; proc print data=sashelp.class;run; ods html close; ods results=off; ods html file="d:\pseudoexcel.xls" style=minimal; proc print data=sashelp.class;run; ods html close; ods results=on; ... View more