Learning SAS? Welcome to the exclusive online community for all SAS learners.

insufficients space; SAS University Edition

Reply
New Contributor
Posts: 3

insufficients space; SAS University Edition

I sorted file ( 6 GB). Then an error has occurred .

What's the problem? I think lock of SAS-Universtiy-Edition which temporary folder of virtual machine limits about 10 GB.

SAS Universtiy Edition

VirtualBox (virtual harddisk; 100GB) (I operated in VMware player. same results)

real desktop

RAM; 16G

Hard; 2TB

operation; window 7

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 /*sorting nps2009_2011_20_essential2_f */

44 proc sort data=aaa.nps2009_2011_20_essential2_f;

45 by year NO;

46 run;

ERROR: Insufficient space for writing Filename =

  /tmp/SAS_util000100000690_localhost.localdomain/ut0690000005.utl.

ERROR: Failure while attempting to write page 3508 of sorted run 7.

ERROR: Failure encountered while creating initial set of sorted runs.

ERROR: Sort execution failure.

NOTE: 40807285개의 관측치를 데이터셋 AAA.NPS2009_2011_20_ESSENTIAL2_F.에서 읽었습니다.

NOTE: 프로시저 SORT 실행(총 프로세스 시간):

47 ;

48 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

58 ;


1.PNG
Super User
Posts: 7,782

Re: insufficients space; SAS University Edition

When sorting a 6GB file, you need 18 GB of disk space.

6GB for the original file.

~6GB for the utility file

6GB for the new file (if you use out=) or the original .sas7bdat.lck file

Only when you're done, the space for the original file and the utility file is released.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: insufficients space; SAS University Edition

Posted in reply to KurtBremser

I think my hard disk is enough for operation.

Harddisk is 2TB...

The default virtual harddisk of SAS university edition  is 10 GB. So I enlarged virtual machine (VMware and virtualbox) up to 100 GB.

But not operated... So I thinks temporary folder size of inner virtual machine (cannot changed)  is limited until 10 GB....

maybe limitation of universtiy edition...

Super User
Posts: 11,343

Re: insufficients space; SAS University Edition

Try the TAGSORT option which may reduce the size of temporary files needed.

Super User
Posts: 7,782

Re: insufficients space; SAS University Edition

And consider that SAS UE is a learning tool not intended for "production" data. 6GB is very much beyond an example case.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 3,213

Re: insufficients space; SAS University Edition

Cnnsb, you are right is the VM machine setting of the UE (dentos) that are limited, not your windows one.

---->-- ja karman --<-----
New Contributor
Posts: 3

Re: insufficients space; SAS University Edition

Thanks a lot.

I confirmed SAS UE limitation.

Ask a Question
Discussion stats
  • 6 replies
  • 1650 views
  • 0 likes
  • 4 in conversation