I have been working with proc report and proc sgplot to send output to ODS Excel.
I am summarising some sales data by year and month to give me a comparison of how monthly sales have changes over time.
To get the graph to present month name instead of number, I have used the following:
axis1 label=none value=('JAN' 'FEB' 'MAR' 'APR' 'MAY' 'JUN' 'JUL' 'AUG' 'SEP' 'OCT' 'NOV' 'DEC') order=1 to 12 by 1 offset=(2) width=1;
In proc report, I can use the same variable to get a nice summary of month across my table, but I can't seem to find a method to get the same results as the graph...
Here's my proc report code:
proc report data=volume_cummulative(where=(year > "&base_year")) split="*" style(header) = [font_weight=bold font_size=8pt color=black bordertopstyle=solid bordertopwidth=0.1pt bordertopcolor=black borderbottomstyle=solid borderbottomwidth=0.1 borderbottomcolor=black backgroundcolor=cornflowerblue just=center] style(column)=[font_size=8pt]; column year month, (cumm /*revenue Invoice_Price*/); define year / group "Year" style(header)=[just=left] style(column)=[font_weight=bold]; define month / group across order=internal style(header)=[just=center] "Month"; define cumm / analysis sum format=comma12.2 "Volume"; run;
Any ideas warmly welcomed.
SAS Analytics Pro (9.4 M6)
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.