Hello, I wrote some proc templates to create some graphs and pies, but after outputting them for export to excel, they become extremely small. Even in excel it takes the size of 1 row and even smaller. What am I doing wrong? Here is an example of my Macro to create a pie: %macro Pie_S(Category, response, dataIn); proc template; define statgraph pie_S; begingraph / datacolors=(&fillcolors_graphs_S) attrpriority=none; layout region; piechart category=&Category response=&response / outlineattrs=(pattern=2 color=lightgrey) datalabellocation=outside categorydirection=clockwise start=90 name= 'pie'; endlayout; endgraph; end; run; proc sgrender data=&datain template=pie_S ; run; %mend Pie_S; I export with ODS Excel (for confidentiality reasons I've put X's where needed): ods excel file= "XXXX.xlsx"; ods excel options(sheet_name='XXX' embedded_titles='no'); %pie_s(gegevens,percentage,XXX); ods excel options(sheet_name='XXX' embedded_titles='no'); %pie_s(gegevens,percentage,XXX); ods excel options(sheet_name='XXX' embedded_titles='no'); %pie_s(gegevens,percentage,XXX); ods excel close;
... View more