topic Re: Error While creating graph in SAS Studio in SAS Studio

Error While creating graph in SAS Studio

jaycss — Tue, 20 Feb 2018 09:22:44 GMT

Hi,

I am learning SAS Studio. I want to create Bar chart in SAS Studio. I have data set with row count of 7453215. When I am execute SAS program to create Bar Chart it throws me following error.

ERROR: The data to be rendered has exceeded the MAXOBS limit of 2000000. You can set MAXOBS=7453215 on the ODS GRAPHICS statement to render the graph.

I have tried to set firstobs=1 obs=7453215 also.

ods graphics / reset width=6.4in height=4.8in imagemap;

proc sgplot data=MYLIB.TBL2007;
	vbar FlightNum / group=Year groupdisplay=cluster;
	yaxis grid;
run;

ods graphics / reset;
run;

But it did not work for me. Do I committed any mistakes or driving in wrong direction? Give me some suggestion. Thank you.

Re: Error While creating graph in SAS Studio

andreas_lds — Tue, 20 Feb 2018 08:30:53 GMT

And what happened with maxobs set to 7453215?

The log is text, so please post is using {i} icon.

Re: Error While creating graph in SAS Studio

RW9 — Tue, 20 Feb 2018 09:04:19 GMT

You have hit a limitation of not just SAS, but the human eye. No graph should be displaying 7453215 observations, a normal size graph would not have space to display a fraction of this.

Summarise your data by your categories - this will be x or y axis depending on direction of bar, then plot the summarised data. For instance, if I have a dataset with subject,age and val with 20,000 records I could try plotting that, or I could ascertain what categories I want to see in my graph and then summarise (maybe mean, high/low, standard deviation etc.).

Re: Error While creating graph in SAS Studio

jaycss — Tue, 20 Feb 2018 09:20:23 GMT

Still facing same error.

Re: Error While creating graph in SAS Studio

jaycss — Tue, 20 Feb 2018 09:21:52 GMT

But what if i want to analyse all record for particular purpose ? Still do I need to summarized my data ?

Re: Error While creating graph in SAS Studio

RW9 — Tue, 20 Feb 2018 09:49:08 GMT

"But what if i want to analyse all record for particular purpose" - please define.

I would recommend you summarise. The point of a graph is to show in simple shapes the data, plotting every single point in a dataset will almost never create a viewable graph. Decide what you want to see in the graph, what is the bar your trying to show, is it the maximum, or the count or something else. Then organise the data to show just the results you want to see, then plot those. A simple example, I could take the data from sashelp.class, and plot M/F against age, this would make my Xaxis have lots of individual columns, as there are many ages. This is not conducive to easily looking at the data, so in this instance I take the decision to sum by age category which I create, in this way I may have 3 or 4 xaxis columns, and the data is easy to view. Without knowing your problem I cant suggest.

Re: Error While creating graph in SAS Studio

athienitis — Tue, 05 Mar 2019 15:58:27 GMT

Try setting your maxobs higher:

ods graphics on / obsmax=11000000;
proc sgplot data=out;
scatter y=y x=x/group=cluster;
run;
ods graphics off;