How to include >200 midpoints for axis1 in GCHART

[Anna_h]

I can plot 125 midpoint nicely with this code below (SAS 9.2). When data piont go up to 262, I got the error massage. Do any one know a solution? proc gchart data=final anno=anno1; where arm=1; vbar count/ discrete sumvar=chg ascending noframe raxis=axis1 maxis=axis2 width=.2 space=0.4; run; quit; LOG: ERROR: There were 262 midpoints generated from the data. Specify levels=all to display the graph.

[ballardw]

As the error says include LEVELS=ALL in the options to the VBAR.

For legibility you may need to increase the space available for your graphics output.

Alternatively you might investigate PROC SGPLOT with a NEEDLEPLOT though that might require presummarizing the data before plotting.

[Anna_h]

Helpful suggestion thank you! I will try. By the way, what is the number limit for gchart using discrete, or we can change setting somewhere?

[ballardw · Accepted solution]

I did a test and it seems that 200 is the limit for Gchart with discrete VBAR.

The Needleplot doesn't have a limit though the display size may mean that there isn't much visible space between the vertical lines.

Here is a very brief example:

data needle;
   do xvar = 1 to 400;
      yvar = abs(200-xvar);
      output;
   end;
run;

ods graphics on;

proc sgplot data=needle;
   needle x=xvar y=yvar /
   ;
run;

ods graphics off;

Needleplot would require presummarizing data but I seldom used gchart to do the summaries anyway as I often needed to provide tables as well as charts.

[Anna_h]

Thanks a lot!