And that was it.  The entered_date was a datetime.  Just needed to put in a datepart() and it took care of it.  Thanks so much for the help! ... View more

Just as Art said. You can firstly make a macro to include these SQL proc print, then use call execute to loop this macro. Ksharp ... View more

Jeff; You could use proc format to create labels for the order values. To eliminate the "Order=", try label order='00'x; Lastly, pie charts are a rather ineffective and inefficient way to present data and especially so when trying to make comparisons across "Orders". Consider the use of vbar or hbar charts by "order". Label the response axis or the title with a statement that indicates that each bar represents a proportion of the whole. The resultant display will be much more effective. For a "treatise" on circular charts and alternatives, see http://www.perceptualedge.com/articles/visual_business_intelligence/our_fascination_with_all_things_circular.pdf ... View more

Excellent. Again, thanks for all the help. ... View more