BookmarkSubscribeRSS Feed
anandbillava
Fluorite | Level 6
I am creating a report using proc report which pulls data from oracle databse using proc sql. It takes lot of time when i run it in my local SAS and it crashes when running in Enterprise guide. It gives error saying ERROR: Utility file write failed. Probable disk full condition.
or dataset is corrupted. Some of the datasets in this joining has more than 200,000 records.

Once the above dataset created from proc sql there are some internal processing required. Some time it crashes during those steps saying dataset is corrupted.

Any idea about handling such a big table ? Any tips would be appreciated..
Thanks in advance.

Message was edited by: anandbillava

Message was edited by: anandbillava

Message was edited by: anandbillava Message was edited by: anandbillava
3 REPLIES 3
Doc_Duke
Rhodochrosite | Level 12
You just need more disk space for UTILLOC. Search for on support.sas.com
LinusH
Tourmaline | Level 20
So you are running EG using a local SAS installation, with ACCESS to Oracle?
If so, try to make the join to happen in Oracle. Use either explicit SQL pass-thru, or try to make your SQL join as clean as possible to make SAS to do a implicit pass-thru.
This will probably make the disk full problem go away.

/Linus
Data never sleeps
Peter_C
Rhodochrosite | Level 12
anandbilliva

to see what is going on under the syntax layer, use the system option SASTRACE, like:
options sastrace=',,,d' sastraceloc=FILE "~somewhere/problem1.log" nostsuffix;
Additionally, in the proc sql statement, add option _TREE.
When you get a lot of details in the SASlog from _TREE, probably your query will be inefficient. You want a report from _TREE showing that the bulk of the query has been passed to the database server.

good luck
PeterC

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1170 views
  • 0 likes
  • 4 in conversation