Desktop productivity for business analysts and programmers

Unable to create pie chart

Reply
Super Contributor
Posts: 434

Unable to create pie chart

When I tried to create chart in EG 5.1, I got the error as follows. My data has only only 4 rows and 4 columns as well.

ERROR: Unable to allocate sufficient memory. At least 469K bytes were requested, but only 45K were available. You must either increase the amount of memory

       available, or approach the problem differently.

ERROR: Driver SASGDGIF will not load.

ERROR: Device was not specified.

Can some suggest the workaround to increase the amount of memory ?

Super User
Posts: 7,446

Re: Unable to create pie chart

Some hints:

13920 - "Unable to allocate sufficient memory" or "SASGDGIF will not load"errors received when expor...

And look at your overall constraints (memsize) and possibly memory constraints imposed by the server operating system upon the userid that runs the spawner.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

Any possibilities to add the below code in EG (likely in tools->options->??) once and use the same for all my sessions instead of adding this everytime while creating charts?

options maxmemquery=1M;

Super User
Posts: 7,446

Re: Unable to create pie chart

There is an option for code to be sent to the server when the connection is established.

Look in Tools - Options - SAS Code

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

I added the code in Tools - Options ->SAS Programs->submit SAS programs when server is connected. But it is throwing me an error as I got earlier.

Super User
Posts: 7,446

Re: Unable to create pie chart

Did the options statement work if included in the code immediately before the graphic proc?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

Yes, It did worked when I added in code.

Super User
Posts: 7,446

Re: Unable to create pie chart

Once you have established a server connection, look in the server intialization log (rightclick on the server in the server list, Properties, Software) if the statement is executed.

Also make sure that you have no contrary statement in the custom code to be executed before tasks and codes.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

May I request you to elaborate your reply. I don't know to find the server list in SAS EG. My SAS was installed in Cygwin enviornment.

Super User
Posts: 7,446

Re: Unable to create pie chart

The server list is an integral part of the EG user interface. If not visible, select View - Serverlist from the main menu.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

I checked the server initialization log and there is no evidence that my statement in 'Tools - Options ->SAS Programs->submit SAS programs when server is connected' is exceuted.

Super User
Posts: 7,446

Re: Unable to create pie chart

After writing the code in the window, did you activate the option?

I put a simple %put "Killroy was here"; in there and immediately got in on my next new server session.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super Contributor
Posts: 434

Re: Unable to create pie chart

I didn't activate either. So do you want me to reconnect my session after saving my code to activate my option?

Super User
Posts: 7,446

Re: Unable to create pie chart

You have to make sure that there is a tickmark next to "submit SAS programs when server is connected", and, after saving your changes, you need to terminate the server connection and restart it. Nest time you start your EG and connect to the server, the code will be executed automatically.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 14

Re: Unable to create pie chart

Please show us the data, and describe what kind of pie chart you want.

I'd be interested in seeing what kind of request caused this problem.

Ask a Question
Discussion stats
  • 14 replies
  • 598 views
  • 7 likes
  • 3 in conversation