Automatic change of Major Ticks while sending and saving graph to MS Word, from SAS EG

ankit_shah — Mon, 25 Feb 2019 14:05:43 GMT

I am creating a graph, using last 6 months data, starting 01AUG2018. Upon generating the graph, I got the graph as expected with major ticks as AUG18, SEP18, OCT18, NOV18, DEC18, JAN19 and FEB19.

Upon sending it to MS Word, using "Send to" button, I am getting the same graph with major ticks as AUG18, SEP18, OCT18, NOV18, DEC18, JAN19 and FEB19.

But, when saving the graph, the SEP18 major tick changes to AUG18 and the magor ticks transform as AUG18, AUG18, OCT18, NOV18, DEC18, JAN19 and FEB19.

SAS EG Version: 7.13

MS Word Version: 2010

Re: Automatic change of Major Ticks while sending and saving graph to MS Word, from SAS EG

SuryaKiran — Mon, 25 Feb 2019 15:02:01 GMT

Hello @ankit_shah,

What output destination did you mention in the settings (Tools>Options>Results>Select Html here ). If not HTML, try with HTML. Alternatively you can create the RTF reports as your destination reports, Word can read it and you can create more fancy reports using ODS RTF.

data one;
input trt_group time subject results;
   datalines;
1 2 100 20
1 4 100 30
1 6 100 35
1 8 100 50
1 2 200 40
1 4 200 25
1 6 200 40
1 8 200 30
1 2 300 25
1 4 300 40
1 6 300 45
1 8 300 55
2 2 400 15
2 4 400 35
2 6 400 50
2 8 400 45
2 2 500 35
2 4 500 35
2 6 500 20
2 8 500 35
;
run;

ods rtf file='/coe_grp/KiranP/test/Study_Results.rtf';
proc sgplot data=one;
   title 'Study Results by Treatment Group';
   series x=time y=results / group=subject grouplc=trt_group name='grouping';
   keylegend 'grouping' / type=linecolor;
run;

ods rtf close ;

topic Automatic change of Major Ticks while sending and saving graph to MS Word, from SAS EG in ODS and Base Reporting

Automatic change of Major Ticks while sending and saving graph to MS Word, from SAS EG

Re: Automatic change of Major Ticks while sending and saving graph to MS Word, from SAS EG