Hi,
I keep getting the error:
ERROR: Insufficient space in file WORK.VISITSADULTCOUNT.DATA.
ERROR: File WORK.VISITSADULTCOUNT.DATA is damaged. I/O processing did not complete.
when I want to run the following code:
data VisitsAdultcount;
set visitsadult;
ynomenc=year(SS00015);
by H18;
if First.H18 then do;
visitsA=0;
if (ynomenc GE startFU) and VERSTR_CARDIO_VOLW=1 then visitsA+1;
if (last.H18) then /*loop for 1 patient*/
output;
end;
run;
H18 is my ID variable and my dataset contains approximately 15 million records. I want to count the number of visits for every person in the dataset.
Any idea how I can fix this or any other code I could use that wont give this issue?
Thanks!
You've run out of disk space for your WORK dataset. Are you running SAS locally on your PC or on a remote SAS server?
If you are running SAS on your PC then delete any files you no longer need to free up space. Check your SASWORK folder to see if there are any old sub-folders that can be deleted.
If you are running remote SAS then consult your SAS administrator to free up more space.
I am running remote SAS, but my work folder is as good as empty.
Contents of your folder doesn't say whether you are running out of disk space or not.
Contact you server admin to get help of analyzing disk space and your program behaviour.
Adding some options <might> give som more input on whats going on (in the future, provide the full log, instead of splitting up the message and the code):
options msglevel=i fullstimer;
On a remote server you will be sharing the WORK folder with other users who could be filling it up. Like I said, talk to your SAS admin.
Use this option to re-direction your WORK library.
options user='d:\temp\';
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.