topic Re: Very small Pies and Graphs in Graphics Programming

Very small Pies and Graphs

AScraeyen — Thu, 17 Mar 2022 15:12:09 GMT

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;

Re: Very small Pies and Graphs

ballardw — Thu, 17 Mar 2022 15:42:29 GMT

What are your current settings for ODS GRAPHICS options?

You may need to specify some size units in Height and Width options such as

ODS GRAPHICS Height=5in Width=7in;

which would set the display to 5 inches by 7 inches Or the equivalent in the GTL DESIGNWIDTH and DESIGNHEIGHT options of STATGRAPH in your template. The defaults are defined in pixels and with a high resolution screen pixels are pretty small.

Re: Very small Pies and Graphs

AScraeyen — Fri, 18 Mar 2022 08:09:58 GMT

Unfortunately, I tried already to fix the size, but that doesn't change this problem. I can make graphs one moment, and the next time I run my code, they become really really small...

Re: Very small Pies and Graphs

AScraeyen — Fri, 18 Mar 2022 12:44:48 GMT

with 5in on 5in it gives the same result in sas (and the same size in excel):

rather small and difficult to read / analyse, no?

Re: Very small Pies and Graphs

AScraeyen — Wed, 23 Mar 2022 10:12:48 GMT

I found the mistake I made. In the overall code, I left a ods graphics with the wrong size (I mixed up inches, pts and cm, as I usually use the European standards). Removing the ods graphic and letting SAS choose the best format, solved the problem.