topic Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram in Discussions

Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

vinkane — Tue, 28 Jul 2015 14:30:27 GMT

Unable to develop summary tables when using data tables in excess of 4M rows.

Frequently get pop up windows dealing with "Memory type issues"

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

Eric_Hill — Tue, 28 Jul 2015 17:05:05 GMT

How many columns per row, and what data types? If each row requires ~1000 bytes, that would be 4GB. Doing analysis on top of that, you could easily be pushing the boundaries of 8 GB.

Eric

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

vinkane — Tue, 28 Jul 2015 18:02:58 GMT

Eric: Thanks for the reply. About 12 columns, dates, numeric and character type columns.

I'm not bugging IT for some more RAM

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

Eric_Hill — Tue, 28 Jul 2015 18:07:54 GMT

Okay, assuming your character columns are not quite large, it does seem surprising that you are running out of memory. You may want to run this one through SAS Tech Support.

Are there some platforms that you can run on this data without running out of memory? Or have you only tried Tables > Summary?

Thanks,

Eric

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

markschahl — Thu, 30 Jul 2015 04:38:34 GMT

A basic question about your machine. What OS are you running? 32-bit or 64-bit? If you have a Win7 32-bit machine, it can only access 4GB, even though you may have 8GB installed. If this is the case, you will have to wipe the HD, install Win7 64-bit to access the the 8GB. I speak from experience... It was worth the pain to wipe HD and reinstall 64-bit versions of my software.

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

ron_horne — Thu, 30 Jul 2015 14:41:05 GMT

I get the same when working with scripts that include very long loops of huge tables simultaneously . in my case it turned out that if i send several messages to the same object it happens while sending each message separately and repeating the name of the object each time it doesn't happen at all.

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

briancorcoran — Thu, 30 Jul 2015 17:47:19 GMT

On a 32-bit machine, while the OS has access to 4GB JMP only has access to 2 GB. So, there are serious constraints there.

Brian Corcoran

JMP Development

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

vinkane — Thu, 30 Jul 2015 18:05:52 GMT

Yes, I have tried summary tables which I found that there was no summary table constructed and there was no log entry.

That was the original SAS issue I logged in.

Re: Frequently receive out of memory pop ups when working with a data table approx 4M rows. My Lenovo has 8GB ram

vinkane — Thu, 30 Jul 2015 18:06:40 GMT

Thanks for this insight. I'll try this suggestion with the help of IT