Generally, Y axis starts from non –zero is not suggested, especially for bar chart. Because it often brings us an illusion vision. ... View more

Thanks Sanjay. Graphically Speaking is a very nice blog, I have learn a lot from it . For broken axis with double slash, like this:  "// ",  drawtext statement in PROC Template would be better. Here is an example: proc template; define statgraph sgdesign; dynamic _SEX _HEIGHT; begingraph;    entrytitle halign=center 'Height by gender';    entryfootnote halign=left 'Broken axis demo';    layout lattice / rowdatarange=data columndatarange=data rowgutter=10 columngutter=10;       layout overlay /          yaxisopts=( type=linear                      offsetmin=0.0                      griddisplay=on                      linearopts=( viewmin=0.0                                   viewmax=80.0                                   minorgrid=OFF                                   minorticks=OFF                                   tickvaluepriority=TRUE                                   tickvalueformat=BEST6.                                   tickvaluelist=(40.0 50.0 60.0 70.0 80.0)                                   tickdisplaylist=("0" "50" "60" "70" "80")                                  )                    );          boxplot x=_SEX y=_HEIGHT / name='box' groupdisplay=Cluster;          drawrectangle x=58 y=128 width=4 height=4 /             display=all outlineattrs=(color=white) fillattrs=(color=white)             transparency=0  drawspace=graphpixel anchor=left;          drawtext textattrs=(size=12pt) "/" / x=55 y=138  rotate=-45             drawspace=graphpixel anchor=left border=false TRANSPARENCY=0;              drawtext textattrs=(size=12pt) "/" / x=55 y=120  rotate=-45             drawspace=graphpixel anchor=left border=false TRANSPARENCY=0;       endlayout;    endlayout; endgraph; end; run; proc sgrender data=SASHELP.CLASS template=sgdesign;     dynamic _SEX="SEX" _HEIGHT="HEIGHT"; run; It seems that  you'll come to China on September 4. Hope to see you! ... View more

Thanks for your help. That quit helpful! ... View more

Thanks for your suggestion. I'll find more details from documents. Hongqiu ... View more

Thanks Chris. You got exact what I mean. Editor abbreviations is a kind of choice, but may not the best choice, Since Macro I defined may have lots of  positional parameters. Auto-completion can also give some hints of what these parameters means  when I 'm typing in EG, but Editor abbreviations will not. Macro Auto-completion  can only be done in the some code node in EG.  If EG can do this in different code nodes, that would be better. Thanks. Hongqiu. ... View more

Two ways can get R square into a data set. For most of Stats model, OUTEST is a very useful option ODS OUTPUT statement A demo code as follows: ods output  FitStatistics=FitStat; proc reg data=sashelp.class outest=aa RSQUARE ;     model weight=age height; quit; Good luck! Hongqiu ... View more

Keyboard MACRO may be a solution. Any other method? ... View more

Yeah,  thanks. You are right. I'm a little confused about the two words 'comma' and 'semicolon'.    I am not a native English speaker. ... View more

I used the data you posted. csv file is ";" separated file, actually it is the same as  txt file. you can choose what fields you want to read in or drop for csv files.but no options available  for excel files as far as I know. ... View more

pls try my updated code. ... View more

Thanks. mcompilenote  is a very useful opiton. ... View more

It's ok for me . I think it may related to your SAS Version. BTW, my SAS Version is 9.3 TS1M2. ... View more