topic Re: Quick and dirty solution for running out of space in SAS Studio? in New SAS User

Quick and dirty solution for running out of space in SAS Studio?

Jarot741 — Fri, 30 Nov 2018 03:07:26 GMT

Hi all,

First of, I have seen different "solved" posts regarding this subject. I am a very new sas user and even with those directions I cant derive to a solution.

Background:

I have several datasets (.csv format) that were meant to be put together in Postgres, but I am trying to learn how to use SAS and would like to combine them in SAS. Keyword to combine is a numeric variable patientUnitStayID (Somewhere around a million observations and 300 variables total)

Problem:

I have been doing so by merging tables, but every now and then I get this annoying "out of space message"

Questions:

Is there a quick and dirty solution for this? (besides buying more storage)

Thank you in advance,

Re: Quick and dirty solution for running out of space in SAS Studio?

SASKiwi — Fri, 30 Nov 2018 03:12:59 GMT

Try adding this statement at the start of your program: options compress = binary; This will compress all of the SAS datasets written after this statement and may give you enough breathing room to avoid running out of space.

Re: Quick and dirty solution for running out of space in SAS Studio?

Reeza — Fri, 30 Nov 2018 03:14:36 GMT

Are you using SAS UE?
Did you redirect your work library?
What are your RAM settings for the VM?

One million observations isn't much, but 300 variables is. Make sure you're not keeping multiple copies around as well, that will problematic.

Re: Quick and dirty solution for running out of space in SAS Studio?

Jarot741 — Fri, 30 Nov 2018 04:08:59 GMT

Reeza,

If you have time to show me how to redirect the work library on my mac I would really appreciate it.

And yes I am using SAS UE.

I owe you the VM settings (I am not using that PC right now).

Thanks again,

Re: Quick and dirty solution for running out of space in SAS Studio?

Jarot741 — Fri, 30 Nov 2018 04:10:20 GMT

SASKiwi,

Thank you for your tip!, I will use it tonight and for sure let you know.

Thanks again,

Re: Quick and dirty solution for running out of space in SAS Studio?

Reeza — Fri, 30 Nov 2018 04:55:27 GMT

Create a library called users that points to where you want the files to be stored. Likely a subfolder under myfolders. You’ll have to manually clean it up though. And you’ll also need to set up the user library whenever you start up. You can add it to your autoexec to do that.

Re: Quick and dirty solution for running out of space in SAS Studio?

Jarot741 — Fri, 30 Nov 2018 21:02:09 GMT

It worked! Thanks again!