Insufficient Memory Issue

[Suzanne McGuire]

I am assisting a with the running to the cmmi bundle program. We ran
out of space within the work library. Is there a way to change the
default work library to a different drive with more memory?

We tried to change the work libname ( libname work 'X:\SASTEMP';) but
it said the SAS work library cannot be reassigned. Here is the Log
with the insufficient memory error:


EXCERPT FROM LOG

1356 proc sql ;
1357 create table service_codes_sum (index = (key = (bene_id
claim_no_grp claim_number ))
1357 ! ) as
1358 select
1359 bene_id, from_dt, claim_no_grp, claim_number, file_type,
1360 code_type, code_loc, code_value, poa_value, mdfr_cd1,
mdfr_cd2, rev_cntr, apcpps,
1360 ! code_pckgind,
1361 sum(code_amt) as code_amt,
1362 sum(code_units) as code_units
1363 from
1364 service_codes
1365 group by
1366 bene_id, from_dt, claim_no_grp, claim_number, file_type,
1367 code_type, code_loc, code_value, poa_value, mdfr_cd1,
mdfr_cd2, rev_cntr, apcpps,
1367 ! code_pckgind ;
ERROR: Insufficient space in file WORK.'SASTMP-000000102'n.UTILITY.
ERROR: File WORK.'SASTMP-000000102'n.UTILITY is damaged. I/O
processing did not complete.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax
of statements.
1368 quit ;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 2:20:53.07
cpu time 28:33.98

[Elizabeth Bailey]

Here is a good example of how to redirect your temp files:

http://www.ats.ucla.edu/stat/sas/icu/custom_win_92.htm

--
Elizabeth (Siteman) Bailey

Program Implementation Leader

Central Region

Health Care Incentives Improvement Institute

(e): elizabet...@hci3.org

(o): 989.486.1428

(c): 757.630.4235

www.hci3.org

 Visit HCI3 on Facebook