topic Re: SAS Studio large dataset error in Administration and Deployment

SAS Studio large dataset error

PunkinSAS08 — Mon, 29 Jan 2024 00:31:06 GMT

Hi,

I am using the University sas studio version and working with large datasets for my practicum. After running a few data sets, I start receiving the following errors that prevents me from running future code:

ERROR: Error opening file. File =/saswork/SAS_work868100004FE6_odaws02-usw2-2.oda.sas.com/#LN00081. System Error Code = 122.

ERROR: Invalid open mode.

ERROR: No body file. HTML5(WEB) output will not be created.

Can someone assist with this? I have cleared my library but that has not fixed the issue.

Re: SAS Studio large dataset error

SASKiwi — Mon, 29 Jan 2024 01:04:47 GMT

I would start by adding the COMPRESS option to each of the large datasets:

data Want (compress = yes);
  set Have;
run;

That should allow you to process more data. If that isn't enough then delete any earlier datasets in your program that you no longer need:

proc datasets library = WORK;
  delete Have;
  run;
quit;

Re: SAS Studio large dataset error

PunkinSAS08 — Mon, 29 Jan 2024 20:03:17 GMT

This allowed me to run more additional datafile but it's ultimately filled past that point. What if I switched all the datasets over into permanent sas libraries, would this combat the issue? I am currently working with large CSV files and could potentially switch them to sas7bdat form and try this way.

Re: SAS Studio large dataset error

PaigeMiller — Mon, 29 Jan 2024 20:34:34 GMT

Generally, WORK data sets and permanent SAS data sets take up the same amount of space.

If you are using SAS/Studio via SAS On Demand for Academics, there are also size limits which would potentially prevent you from working with huge data sets.