topic Re: SGPLOT VBAR maximum data points on xaxis reached in Graphics Programming

SGPLOT VBAR maximum data points on xaxis reached

Jim_Cooper_hmsa — Mon, 16 Aug 2021 22:13:29 GMT

I have been running report that produces a bar chart of the daily COVID-19 hospital admissions from March 15 2020 to current. The bar chart stops displaying dates after July 14, 2021. Is there a limit to the number of bars that can be displayed in a VBAR chart?

Is there an option that will allow me to display the whole time line from March 15 2020 for the forseeable future or do I have to start sampling the data points?

Re: SGPLOT VBAR maximum data points on xaxis reached

ballardw — Mon, 16 Aug 2021 22:27:53 GMT

It won't hurt to show your code.

If you are using an option to force a tick mark for every date that might limit things.

I would typically use a Needle plot to show a large number of values like this.

Example creating some dummy count data per day and displaying it.

data example;
  do date='01Jan2020'd to '31DEC2021'd;
     value= rand('integer',100);
     output;
  end;
  format date date9.;
run;

Proc sgplot;
   needle x= date y=value;
run;

Re: SGPLOT VBAR maximum data points on xaxis reached

Jay54 — Mon, 16 Aug 2021 23:13:32 GMT

See this thread on DISCRETEMAX:

https://communities.sas.com/t5/Graphics-Programming/Increase-the-max-number-of-groups-how-to/td-p/55128

Re: SGPLOT VBAR maximum data points on xaxis reached

Jim_Cooper_hmsa — Mon, 16 Aug 2021 23:18:15 GMT

Here is the PROC SGPLOT statement that I am using. The data is 403 observations for admissions from March 15, 2020 - August 15, 2021. The last data point in chart is July 21,2021

proc sgplot data=CovidAdmitSummary;
vbar CovidAdmitDT /response=Admissions nooutline barwidth=.7 missing;
xaxis fitpolicy=rotatethin interval=day ;
yaxis label='# Admissions' max=20 grid gridattrs=(color=lightblue pattern=1 thickness=.5);
format CovidAdmitDT date5.;
label CovidAdmitDT='Day of Admission';
run;

Re: SGPLOT VBAR maximum data points on xaxis reached

ballardw — Mon, 16 Aug 2021 23:25:59 GMT

It is extremely easy to test the needle plot.

Change your code to read

needle x=CovidAdmitDt y=Admissions;

instead of the VBAR you are currently using.