Code based automated is absolutely possible with SAS! ods pdf file="c:\Directory\filename.pdf" author='your name'; proc gslide; note h=5 j=c c='cx969696' 'Weekly'; note h=5 j=c c='cx969696' 'Usage'; note h=5 j=c c='cx969696' 'Report'; note h=5; note h=2 j=c c='cx969696' "&start to &end"; run; quit; ods pdf close; ... View more

Juan; It would be most helpful if you could post some of the program code that you are using ... ... View more

Sometimes one has to do both - what they want and what they need. Sometimes they see the light! ... View more

Dave; There are at least 3 styles that will do that - analysis, rsvp and torn. HOWEVER: using bold outlines emphasizes the table and de-emphasizes the data in the table. The sole purpose of a table (or a graph) is to let the data tell the story that's in it. May I suggest that you cruise around in http://www.perceptualedge.com and read some very good literature on data visualization. You might like to start with this article - http://www.perceptualedge.com/images/Effective_Chart_Design.pdf ... View more

I don't think you need to use the picture method. It looks like yymm7. should work for you (untested) wd ... View more

I haven't tried this, but if the description="1.1", were an incrementing macro variable (e.g. description="&level" )inside of a macro pgm section would it not create the additional levels for you? ... View more

If there are blanks in the string, you can fill them with %20, e.g. Issue 158 becomes Issue%20158. ... View more

Rather than attach a file or shortcut, I build a hot link into the email message. Code below. filename mail email ' ' from=("me@company.ca") to=("you@company.ca") subject="Sales Report for %sysfunc(datetime(),datetime13.)"; data _null_; file mail; put "auto email report, brought to you by SAS®"; put " "; put "Double click on the link below to view or print"; put " "; put "\\Drive\Directory\SubDirectory\SalesReport.pdf"; put " "; run; Message was edited by: Bill ... View more

Questions like this one scare me. Complex reports must be made simple, but it isn't often effective to use flashy displays. Take yourself to www.perceptualedge.com, buy and read Show Me The Numbers and then worry about tool choice and methodology. ... View more

Alan; If you would post the code that you have it would be easieer for some one to show you how to tweak it wd ... View more

While it may be possible to write a label vertically, from a readability point of view, it's NOT desirable. I would make every effort to keep all titles, labels & notes horizontal. It's usually a more effective use of the screen / page real estate as well. ... View more

Horizontally: proc sql; create table horizontal as select a.*,b.* from one a, two b where a.key=b.key Vertically; proc sql; create table vertical as select * from one outer union corr select * from two; ... View more

You could store it as a "program" in a directory somewhere and then call it in via a %Include statement as needed ... ... View more

This may call for some exquisite SAS trickery! Some possibilities include adding a new variable that allows explicit ordering and then: Applying a format to that variable to get the appropriate label on the chart or, using an axis statement with tick mark labels e.g. value=(t=1 'ValueName1' t=2 'ValueName2') etc. wd ... View more

The code below produces 2 bars (one inside the other) and one line. The bars are produced by using the symbol i=needle. This is an alternate to annotate. symbol1 c=black i=needle v=none w=125 L=1; symbol2 c=blue i=needle v=none w=75 L=1; symbol3 c=red i=join v=square w=25 L=2; axis1 order=(%ord) offset=(5,5) pct label=('Campaign Start Week'); axis2 order=(0 to 12000 by 3000) offset=(0,0) pct label=(a=90 'Tons'); axis3 c=red order=(40 to 100 by 20) offset=(0,0) pct label=(a=90 'Percent on Order'); ; proc gplot data=all; format weekstrt date7.; plot (wip inspectd)*weekstrt /overlay haxis=axis1 vaxis=axis2 ; plot2 onordfin*weekstrt/vref=87.6 vaxis=axis3; run; ... View more