This interest in producing pie charts counters my interest in and passion for good data visualization (presentation). I'd encourage you to read the linked article as an aid to ensuring that your clients are getting the best possible message from the data that you've carefully collected. http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf ... View more

Looks like you are using proc print; Check SAS help to see the options that are available for this procedure. ... View more

Lawrence; A method I have used is to proc import the original access dataset, append the new data inside of SAS and then proc export the new larger dataset as an over write of the old. Bill ... View more

found the answer ... it should read as: ods PDF startpage=now. The subsequent startpage = no is not necessary. wd ... View more

David; I don't see how to move the label to where you I think you want it. But I fooled the title into the correct location. Try it without the move(1,93)pct. I think it's right where you want it. data test; input x y; datalines; 1 4 2 3 3 6 4 9 5 7 6 1 7 7 8 5 9 2 ; run; goptions reset=all dev=win; title1 '"Right" justifying the Y axis label'; title3 j=l move=(1,93) pct 'Long Axis Label'; *move is optional; axis1 label=none; axis2 label=none; symbol1 i=join l=1 c='cxd7301f'; proc gplot data=test; plot y*x/vaxis=axis1 haxis=axis2 ; run; quit; ... View more

More code needed! What are you doing in the gplot routine that might be interfering with the annotate step? ... View more

Please include some code in your posting. We need to see what you are doing. ... View more

more particularly ... http://robslink.com/SAS/democd22/beye2_info.htm http://robslink.com/SAS/democd22/win2_info.htm ... View more

take a look here - you may find something http://robslink.com/sasgraph.html ... View more

Lynn; I don't see any reference to a specific graphics device after reset=all. For input to Word, I think that the best one to use is the png driver. Some code below that I've used in the past. It produces a png file that can be imported into Word. goptions reset=all rotate=landscape ftext="helvetica" htext=2.0 xmax=6in ymax=3.5in xpixels=1800 ypixels=1050 dev=png gsfmode=replace; filename grf1 '\\technology\qualsysshare\groupspecific\reportsmonthly\reapcovr.png'; goptions gsfname=grf1; proc gslide frame lframe=14 wframe=20 cframe=steel; note h=4; note h=8 j=c "PRODUCT QUALITY REPORT"; note h=2; run; quit; wd ... View more

Thanks Cynthia; I tried the cellpadding in the table statement as you suggested but it didn't seem to produce the desired effect. Since then, I've moved to a different ods template and changed the cellpadding successfully. proc template; define style mytheme; parent=styles.meadow; replace Body from Document "Undef margins so we get the margins from the printer or SYS option" / bottommargin = 0.19in topmargin = 0.19in rightmargin = 0.20in leftmargin = 0.20in; replace Table from output/ cellpadding=1.2pt; end; run; The problem is that cellpadding reduces the white space on all four sides of the value. I only want to reduce the space between rows, not between columns. I increased the format to comma20.0 on the table statement, but the template seems to override that. table Slab_Source_Dim_Cd=''* (SLAB_GRD_FAM_NAME='' all) all*[style=[font_size=6.5pt font_weight=bold]], InvenDate=''* (PROD_GRP_DIM_CD='' all) *invendate2=''*sum=' ' SLAB_LOC_DIM_CD="&sysdate, By Location" * SLABTONs=' ' *sum=' '*format=comma20.0 How then do I reduce between row space independently of between column space? ... View more

Thank you. I have a way to run this in V9, so I'll go there. ... View more