And the second aspect is a access file must preexist before adding inside a new "table" open an empty access 2007 file and retry Andre ... View more

This is due to the facility you use A libname has a libref and a engine in general v9 is subtitued automatically but how can sas guess that it is a access microsoft file libname a access "d:\..." ; will work (tested) without mentionning the engine like excel ole odbc or access how can SAS guess? HTH Andre ... View more

Here is a way to a solution for you [pre] proc gslide; title "test"; run; quit; ods listing; filename outfiles "d:\temp\image1.GIF"; goptions reset =all gsfname=outfiles device=gif gsfmode=replace; ods noresults; proc greplay nofs igout=work.gseg; replay _first_; run; quit; ods results; [/pre] indeed goptions nodisplay did not produce a file but for the replay step you may forbid the output on the screen Andre ... View more

This subject was posted also on sas-l with the same effect Perhaps this may rise the question: Is it a usefull manner of doing? Andre ... View more

Jeff It seems for me that you are asking something without explaning any rules http://en.wikipedia.org/wiki/Sunset secondly : why hashing? Andre ... View more

Chris, Sas institute produce an interresting and short text about this question see rule 1 on page 1 in The fundamentals of merge support.sas.com/techsup/technote/ts705.pdf HTH Andre ... View more

Eva Here a tested result in 9.2.2 but Robert Allison woill surely present anything better and perhaps resolving the appearance of mydate as tha name of the variable HTH Andre [pre] data mygraph; informat mydate ddmmyy10.; input Obs q_aggregat mybyfield mydate wert ; cards; 1 0.20930 2 10.09.2009 0.93528 2 0.21538 2 11.09.2009 0.98630 3 0.22137 2 14.09.2009 100.000 4 0.22727 2 15.09.2009 100.000 5 0.23308 2 16.09.2009 100.000 6 0.23881 2 17.09.2009 0.98230 7 0.33544 4 10.09.2009 0.98565 8 0.33962 4 11.09.2009 0.98898 9 0.33750 4 14.09.2009 0.88032 10 0.33540 4 15.09.2009 0.94600 11 0.33333 4 16.09.2009 0.73171 12 0.33129 4 17.09.2009 0.73291 13 0.77108 5 10.09.2009 100.000 14 0.77246 5 11.09.2009 0.98247 15 0.77381 5 14.09.2009 0.99673 16 0.77515 5 15.09.2009 0.99151 17 0.77059 5 16.09.2009 0.94867 18 0.77193 5 17.09.2009 100.000 19 0.51515 6 10.09.2009 0.96884 20 0.51807 6 11.09.2009 0.95833 21 0.52096 6 14.09.2009 0.95600 22 0.52381 6 15.09.2009 0.96962 23 0.52071 6 16.09.2009 0.93400 24 0.51765 6 17.09.2009 0.82052 25 0.89404 7 10.09.2009 0.45791 26 0.89474 7 11.09.2009 0.95247 27 0.88889 7 14.09.2009 0.87443 28 0.88961 7 15.09.2009 0.96730 29 0.88387 7 16.09.2009 0.62942 30 0.87821 7 17.09.2009 0.69590 31 0.62044 8 10.09.2009 0.91667 32 0.62319 8 11.09.2009 0.98894 33 0.62590 8 14.09.2009 0.96756 34 0.62857 8 15.09.2009 0.99710 35 0.62411 8 16.09.2009 0.79227 36 0.62676 8 17.09.2009 0.99935 ; run; proc gbarline data=work.mygraph; symbol1 value=dot height=5 interpol=join color=red width=2; axis1 label=none order=(0 to 1 by 0.1); axis2 label=none; axis3 label=none order=(0 to 1 by 0.1); legend1 mode=protect position=(middle center inside) shape=symbol(1 cm, 0.2 cm) label=("quarterly" h=0.2 cm position=top ); legend2 mode=protect origin=(10,1.5)cm shape=bar(1 cm, 0.2 cm) value=("sum of wert" h=0.2 cm); format wert percent10.2 q_aggregat percent10.2; by mybyfield; bar mydate / sumvar = wert discrete raxis=axis1 maxis=axis2 ref= 0.95 cref = orange legend=legend2; plot / sumvar = q_aggregat raxis=axis3 legend=legend1; title "#byval(mybyfield)"; run; quit; [/pre] ... View more

David, Thank you for the news Andre ... View more

Eva, Show perhaps some code Andre ... View more

Without any other information about the program how can we guess? Andre ... View more

Celine (now from work) See it is working ods listing close; ods rtf file="d:\temp\greekfigure.rtf" style=minimal; goptions device=png rotate=landscape gsflen=132 border htitle=1 htext=1; proc gplot data=sashelp.class; title2 font=cgreek height=1.5 'a b c d e f g h i j k l m n o p q r s t u v w x y z'; title3 font=cgreek height=1.5 'A B C D E F G H I J K L M N O P Q R S T U V W X Y Z'; axis1 order=10 to 20 label=(font=swiss "La " font=greek " m" font=swiss " des ados"); plot age * weight/haxis=axis1; run; quit; ods rtf close; ods listing; ... View more

Céline In sas graph a greek letter is possible see http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0806A&L=sas-l&P=R22438&D=1&H=0&O=D&T=1 What i have never tested is their use inside the axis statement due to another general ftext choice I never use sasmonospace into sas graphs! Another question is related to your graph : alone or inside an ods destination? Andre ... View more

I think that i was more lucky As my version of 9.2.2 is dated of mid july the %sgdesign; engender after one minute a unattended "Wooaw" reaction! after on the log such processes where executed here only on the second call without samples constructing 401 %sgdesign; NOTE: This is a preproduction version of SAS/GRAPH: ODS Graphics Designer. MPRINT(SGDESIGN): options nonotes noquotelenmax; MPRINT(SGDESIGN): ; MPRINT(GETCONFIGARG): ; MPRINT(SGDESIGN): ; MPRINT(CREATEDATASETS): ; MPRINT(SGDESIGN): ; MPRINT(WRITEOPTIONS): ; MPRINT(WRITEOPTIONS): data _null_; MPRINT(WRITEOPTIONS): file "d:\My SAS Files\work\_TD2904\_option_"; MPRINT(WRITEOPTIONS): length optVal $100; MPRINT(WRITEOPTIONS): array opts{4} $10 ("fmtsearch" "missing" "label" "fmterr"); MPRINT(WRITEOPTIONS): do i = 1 to 4; MPRINT(WRITEOPTIONS): optVal=getoption(opts{i}, 'keyword'); MPRINT(WRITEOPTIONS): put optVal; MPRINT(WRITEOPTIONS): end; MPRINT(WRITEOPTIONS): run; MPRINT(SGDESIGN): ; MPRINT(SGDESIGN): systask kill _grsgdsgn_server_; MPRINT(SGDESIGN): systask command " ""C:\Program Files\SAS\SASFoundation\9.2\sas.exe"" -config ""C:\Program Files\SAS\SASFoundation\9.2\nls\en\SASV9.CFG"" -noterminal -noxcmd -nolog -altlog srvlog.txt -nosplash -objectserver -objectserverparms ""protocol=bridge port=5310 nosecurity cel=none """" " taskname=_grsgdsgn_server_; MPRINT(SGDESIGN): proc jlaunch direct librefs app='com/sas/graphics/sgdesigner/SGDesigner'; MPRINT(SGDESIGN): picklist name='graph/graph.txt'; MPRINT(SGDESIGN): joption name="internal" value="true"; MPRINT(SGDESIGN): joption name="configRoot" value="C:\Program Files\SAS\SASFoundation\9.2\graph\sasmisc"; MPRINT(SGDESIGN): joption name="portNum" value="5310"; MPRINT(SGDESIGN): run; MPRINT(SGDESIGN): option NOTES; MPRINT(SGDESIGN): option QUOTELENMAX; NOTE: Task "_grsgdsgn_server_" produced no LOG/Output. HTH Andre ... View more